• Replies 1 reply
  • Subscribers 701 subscribers
  • Views 71 views
  • Users 0 members are here
Options
Related

"Left to Raise" formula in Pivot Table

Brian Ralston
$organization

Hi All,

I'm trying to write a simple formula, but am getting weird results. 

([Total Fund Goal Amount] -[Total Amount])

I'm trying to get the amount left to raise by subtracting the amount raised from the fund goal.

I'm getting really weird numbers because of the [Total Fund Goal amount] isn't playing well in the 'Values' section.

I hope I'm missing something simple! any input/thoughts are aprecciated.

Thanks,

-Brian 

 

  • $organization
    The concept you are looking for is called Multi-pass aggregation. Multi-pass aggregation is simply grouping the data, so that you do not get inflated totals.
     
    Budget Amounts. Budget Amounts for Performances, Campaigns, Funds, etc. will show up multiple times and will inflate your totals.
     
    Syntax:
     
    SUM ( [Group by Field], MAX([Budget Amount]) )
     
    Example:
     
    SUM ( [Campaign ID], MAX([Budget Amount]) )