1 Reply Latest reply on Jul 12, 2016 8:03 AM by Stephane Marx

    IF Calculation

    Dilyana Suleymanova

      HI there, I would like to calculate "Infomappen in my data set.

       

      This is my dataset:

       

      I would like to calculate all Infomappen which "Activity" ="Order"

       

      This is my first idea for folmula:

      if [Activity]="Order" then

      elsif [Orders]="Infomappen"

      then [Anzahl der Datensätze] END

       

      unfortunately it doesn't work.

      Does anybody have other ideas how to calculate "Infomappen" with "ACtivity" = "Order"

       

      Thank you in advance!

       

       

      Best

      DIlyana