Fraud for last 30 days

sumIf({FRAUD_AMT_USD},dateDiff(now() , {LOADDT},‘DD’) <=30)

I want the sum of fraud for last 30 days is this formula correct

@Nicholas @ErikG Please help

Hi @deepa.singh
what is the result telling you?
Looks right on the first view.

It’s not right for sure

@ErikG - Please review this

Can you create a datediff field only and check if the calculation is correct?


I believe load date is a date in the past and now() will give you current date. DateDiff will then give you a result in the negative. So, just reverse parameters and things should work for you

sumIf({FRAUD_AMT_USD},dateDiff({LOADDT}, now(),‘DD’) <=30)