Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Rounding in Qlikview

HI,

 

i am writing some expression as per below

 

=num ( SUM ({<ScenarioLabel={'Actuals'}>} NumValue) / SUM ({<ScenarioLabel={'Actuals'}>} DenValue), '0.#%')

 

its normal value is 78.26% which is good it is rounding to 78.3%

 

but same expression if value is 75.75% it is not rounding to 75.8 .. can some one help me here .

 

problem is after decimal if it is greater than 5 it is rounding if it is equal to 5 it is not rounding as per above example.

Labels (1)
1 Reply
sunny_talwar

Have you seen this thread? Rounding Errors