Forum Discussion
Anonymous
5 years agoNot applicable
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?
- Anonymous5 years ago
And what purpose does the CALCULATE function serve in your expression?
2 Replies
- AnonymousNot applicable
never mind...I just added a 0- to before Calculate
- AnonymousNot applicable
And what purpose does the CALCULATE function serve in your expression?