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

Why =sum(REVENUE_C) display very small value ?

Hi All

I have a table A , which not display REVENUE_C amount is correct. on average the amount is 10,000,000

Table B i using below expression :-
=sum(REVENUE_C)

it not display not correct value. The value 0.0 or 0.1 , which is wrong , correct value should 19,000,000
May i know why ?

Paul

1 Solution

Accepted Solutions
chakiw5
Contributor III
Contributor III

Check the relative value display of the expression tag, so remove it
The display of the percentage display in the numeric format is checked normally.

I'm sorry if English is wrong

View solution in original post

3 Replies
paulyeo11
Master
Master
Author

Hi All

Enclosed my QVW file

Paul

chakiw5
Contributor III
Contributor III

Check the relative value display of the expression tag, so remove it
The display of the percentage display in the numeric format is checked normally.

I'm sorry if English is wrong

paulyeo11
Master
Master
Author

Hi Chak

Many thank for your help. it work fine now. which is more impt then your english , So don't need to worry about language.

Paul