Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total Not Working in Nested If's

Hi, I have this expression on my chart

ALT(if([Sub Channel] = 'Test Account',IF(((sum({$<[Notification Description] = {'Transaction Funded'}>}Commision))) > 2, 2))

    , (sum({$<[Notification Description] = {'Transaction Funded'}>}Commision)))

It works, but the also sets the total to the first condition. I tried AGGR

ALT(aggr(if([Sub Channel] = 'Test Account',IF(((sum({$<[Notification Description] = {'Transaction Funded'}>}Commision))) > 2, 2)),EXTERNAL_ID)    , (sum({$<[Notification Description] = {'Transaction Funded'}>}Commision)))

but this still doesnt work, any idea how to get my total to sum up correctly.

0 Replies