4 Replies Latest reply: May 4, 2016 2:20 PM by Meg Kish RSS

    Creating a new measure based on 2 existing measures

      How would I create a new measure based on two "defined" measures that are in my dataset.


      The two defined measures as Job.Stop.AmountBillable and Job.StopAmountInvoiced


      I want to create a calculation or measure that shows me the amount not billed, i.e. AmountBillable - AmountInvoiced.

      In excel, I would do =(Job.StopAmountBillable)-(Job.StopAmountInvoiced)


      I did some research on set analysis but I don't see how that could work....