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

    Creating a new measure based on 2 existing measures

    Meg Kish

      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....