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,

      Thomas