Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help! I need a negative value from a basic QUICK MEASURE division

Hello!

I have a basic inquiry into how to derive a negative value to eliminate this negative here: (I have been covering the - up with a white space so far but that is not the solution)

% of Measure Not Met =
calculate(DIVIDE(
    COUNTA('Safety_01_Num'[PreHospital_Report]),
    COUNTA('Safety_01_Denom'[PreHospital_Report])
)* 100-100)
 
Do I need to make this a variable then multiple it by -1 or can't I just do it here?

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    And what purpose does the CALCULATE function serve in your expression?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    never mind...I just added a 0- to before Calculate 

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    And what purpose does the CALCULATE function serve in your expression?