Potential Savings Calculation issue

joshibabu_are — Wed, 22 Mar 2017 20:14:34 GMT

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

Re: Potential Savings Calculation issue

Anil_Babu_Samineni — Thu, 23 Mar 2017 01:53:36 GMT

You should use this for Sum

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