Aggregated by non aggregated

Q&A
,
1

I have a caluclated field :
sumIf({FRAUD_AMT_USD},dateDiff( {RECORD_DATE},now() ,‘DD’) <=30) : This Give me fraud data for last 30 days which is an aggregated field ,

I want divide this by non agreegated field is it possible if yes please help how

2

Hi @deepa.singh ,

the following formula should work:

sum(
    ifelse(
        dateDiff({Order Date}, now() ,"DD") <= 30,
        Sales,
        0
     )
)

Best regards,
Nico

1 Like
3

Hi @deepa.singh,
It’s been awhile since we last heard from you. Did Nico’s response help with your solution or do you have any remaining questions?

If we do not hear back from you within the next 3 business days, I’ll go ahead and mark the solution.

Thank you!

4

Hi @deepa.singh,
Since we haven’t heard back, I’ll go ahead and mark the solution. 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!