Potential Savings Calculation issue

[joshibabu_are]

Hi Guru's,

i have Employee wise Spend Amount.i want to calculate Potential Savings Based on Spend.

i want to trace employees who Spend more than 100$ in a Day.

Formula:Sum(Amount)-(Count(Employee Whose amount >100)*100)

Example:employee E1 spent only one time more than 100$,

So, Actual Calculation Would Be 101-(1*100)=1

Potential Saving should Show 1$ for E1.

Sum(Amount) for E1,01/01/2016 Should be 101 instead of 111.

how to achieve sum(Amount) =101

thanks,

Joshi

[Anil_Babu_Samineni · Accepted solution]

You should use this for Sum

Sum({<Amount = {'>100'}>}Amount)