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


    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!