+ Reply to Thread
Results 1 to 5 of 5

PowerPivot: Calculated field error from Two sheets.

  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    PowerPivot: Calculated field error from Two sheets.

    Hello friends, hope all is well!

    I am working on an excel sheet / pivottable. Please open the image.

    A calculated field was created from two different sheets in the same workbook (divide revenues / number). When I drag the calculated field to the VALUE box I get the error.
    Can you please tell me what to do to have the calculated field run smoothly? What do I need to do?

    Thank you so much in advance
    Attached Images Attached Images

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: PowerPivot: Calculated field error from Two sheets.

    Hi,

    What is the actual formula for the calculated field?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    Re: PowerPivot: Calculated field error from Two sheets.

    =[Sum of Net Revenue]/[Number]

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: PowerPivot: Calculated field error from Two sheets.

    What is Number? It appears to be missing an aggregator function.

  5. #5
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    Re: PowerPivot: Calculated field error from Two sheets.

    You are right, thanks! =[Sum of Net Revenue]/[SUM OF Number]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. adding calculated PowerPivot field to Pivot Table
    By AtlanteanIdol in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2017, 09:49 AM
  2. difference between calculated field and calculated column in PowerpIvot
    By stephme55 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2016, 06:05 PM
  3. PowerPivot calculated field
    By trisoldee in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-26-2015, 11:20 AM
  4. [SOLVED] PowerPivot calculated field error
    By trisoldee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-19-2015, 02:42 PM
  5. Displaying MIN date based on criteria in calculated field of PowerPivot
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-23-2014, 05:25 PM
  6. New calculated Field in Powerpivot
    By ehardway111 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-22-2013, 03:07 PM
  7. Replies: 0
    Last Post: 06-22-2012, 07:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1