Forum Discussion

lawsonbe's avatar
lawsonbe
Icon for Helper I rankHelper 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.

lawsonbe's avatar
lawsonbe
Icon for Helper I rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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