1 Reply Latest reply on Jun 18, 2013 11:55 AM by Matt Lutton

    Calculated fields - difference of fields from 2 data sources

    Aishwarya Balamukundan

      I have 2 measures - Budget and Total Billing. I wish to compute the difference between these 2 columns.i.e Budget - SUM(Total Billing). However, when I try to create a calculated field, it  says all fields must be aggregate or constant.

       

      I am not sure how to go about this exactly. Any help would be great !

       

      Thanks in advance