trying to Aviod Negative symbol in QLikview

[dunnalahk123]

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

[prat1507]

Use this

num ( FABS(SUM ({<ScenarioLabel={'Actuals'},SubMetric={'R'}>} NumValue)  -

SUM ({<ScenarioLabel={'Actuals'},SubMetric={'C'}>} NumValue) ),'0.#;0.#' )

[Anonymous · Accepted solution]

just use fabs()

[dunnalahk123]

HI Robin,

Thank You so Much. 🙂

[dunnalahk123]

Hi Shastri,

Thank You so much 🙂