3 Replies Latest reply: Jun 28, 2017 7:31 AM by Felip Drechsler RSS

    Formula inside IF Statement

    Thomas Ødegaard

      Hi all,


      How do I do two different calculations within the same expression depending on the value in a field?


      I have tried with the calculation below, but it does not work


      If( Source = {'Maintenance'}, Sum([Target], Sum(Aggr(Sum(Target) / Count (distinct SC_ID),YearMonth,[Target Component Group],ID)) )


      My True and False statements works fine seperately, but not when I am trying to combine it in an IF Statement.


      Best regards,