0 Replies Latest reply: Aug 29, 2016 10:41 AM by Azmina Virani RSS

    Total Not Working in Nested If's

    Azmina Virani

      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.