Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to do one subtraction
first value is - 246.4 but with below expression i am converting to 246.4 by removing negative symbol
second value is 134.9
so when try to do subtraction it is not working as expected it is giving me -381.2 but i want it should give me 111.5 which is 246.4-134.9
=num ( SUM ({<ScenarioLabel={'Actuals'},SubMetric={'R'}>} NumValue) ,'0.#;0.#' ) -
num ( SUM ({<ScenarioLabel={'Actuals'},SubMetric={'C'}>} NumValue) ,'0.#;0.#' )
can some one help me please why my condition is not working.
Thank You.
Best Regards,
HK
just use fabs()
Use this
num ( FABS(SUM ({<ScenarioLabel={'Actuals'},SubMetric={'R'}>} NumValue) -
SUM ({<ScenarioLabel={'Actuals'},SubMetric={'C'}>} NumValue) ),'0.#;0.#' )
just use fabs()
HI Robin,
Thank You so Much. 🙂
Hi Shastri,
Thank You so much 🙂