2 Replies Latest reply on Dec 7, 2016 1:50 AM by Daniel Martins

    Calculation

    Daniel Martins

      Hey Guys,

       

      I have the following problem.

      I do have a dataset with "stages" those stages are either ORDERED or CANCELED

      Now, i would like to see my NET orders which means i need a Calculation that somehow works like this:

       

      SUM(STAGE("ORDER") +1 ELSE -1)

      But somehow i am not able to make this work.

       

      So what i need is All Ordered - ALL Cancellations.

       

      IS anybody able to help me out?

       

      Thanks a lot!

      Best,

      Daniel