Fraud for last 30 days

Q&A
1

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

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

2

@Nicholas @ErikG Please help

3

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

4

It’s not right for sure

5

@ErikG - Please review this

6

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

7

@deepa.singh,

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)