Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Finding first sum over 100

Hello All,   I have a Contributions table that has columns: AssetGroup, GiftAmount, FundID, and ID (gifts)   I need to find the sum of the first ID (gift) that is over $100 to a fund.   In our ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous oh i thought you need id, just change the measure

     

    First Id = 
CALCULATE( [Gift Amount],  
TOPN(1, FILTER( Table, [Gift Amount] > [Parameter Value] ), [Gift Amount], ASC )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I changed it to FundID and First ID is now just showing me the FundID, not an actual amount

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous oh i thought you need id, just change the measure

 

First Id = 
CALCULATE( [Gift Amount],  
TOPN(1, FILTER( Table, [Gift Amount] > [Parameter Value] ), [Gift Amount], ASC )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks! You're awesome!