Calculated Field need help

Q&A
,
1

sumOver(ifelse(dateDiff( {RECORD_DATE},now() ,‘DD’) <=30 AND {FRAUD_AMT_USD}> 0,1,0),[{MERCH_ID}])

This calculation is throwing the error , Please help

2

Hi @deepa.singh ,

What is the error that you are getting?

Thanks,
Prantika

3

Hi @deepa.singh

Try this

sumOver(sum(ifelse(dateDiff( {RECORD_DATE},now() ,‘DD’) <=30 AND {FRAUD_AMT_USD}> 0,1,0)),[{MERCH_ID}])

4

still syntax error , Please check

5

Iam getting syntax error

6

Can you try adding PRE_AGG after the partition? This applies if you are using the original formula, but if you are trying with the one @lalprasanth has suggested then you may need POST_AGG.

1 Like
7

Hi @deepa.singh,
It’s been awhile since we last heard from you. Were you able to find a work around for your solution from the help given above or did you have any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

8

Hi @deepa.singh,
Since we haven’t heard back, I’ll go ahead and close this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!