2 Replies Latest reply: Feb 10, 2018 11:23 AM by scott dealtrey RSS

    Using Measure Variables in calculated expressions

    scott dealtrey

      Hi, I created some measure variables and want to complete some calculations.

       

      The two in this example are mocccupancyexp_june & mdirectsalesjune.

      At first I tried just dividing them (column 1), but realized it was incorrect. Columns 2 & 3 are the correct value & column 4 is a division of the two for the right percentage.

       

      I was using =$(moccupancyexp_june) / $(mdirectsalesjune) for the initial calculation, but I must have made a mistake.  The image below has my calculations in the column header. Thanks for any help

      Screen Shot 2018-02-10 at 6.51.42 AM.png