Forum Discussion

lawsonbe's avatar
lawsonbe
Helper I
7 years ago
Solved

subtracting two calculated columns

  I am trying to subtract two calculated columns. I tried a simple subtraction without the Calculate and Sum as well and that gave the same circular reference error. 
Need Help
  • lawsonbe's avatar
    lawsonbe
    7 years ago

    Resolved it by creating a measure for Absent and Present. Oddly, when I tried to delete the calculated column for Absent, the measures stopped working eventhough they no longer referenced the calculated absent column. Just happy I now have an accurate measure.

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

lawsonbe Still not clear, please post what is your actual input data look like and what are the calculated columns you created along with their expressions used. Anyway, you already posted what you want to see as output...

lawsonbe's avatar
lawsonbe
Helper I
7 years ago

Resolved it by creating a measure for Absent and Present. Oddly, when I tried to delete the calculated column for Absent, the measures stopped working eventhough they no longer referenced the calculated absent column. Just happy I now have an accurate measure.

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi lawsonbe,

    It's pleasant that your problem has been solved, could you please mark your reply as Answered?

     

    Regards,

    Daniel He