topic Re: Why =sum(REVENUE_C) display very small value ? in QlikView

Why =sum(REVENUE_C) display very small value ?

paulyeo11 — Mon, 13 Jan 2020 00:57:15 GMT

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

paulyeo11 — Mon, 13 Jan 2020 01:01:40 GMT

Hi All

Enclosed my QVW file

Paul

chakiw5 — Mon, 13 Jan 2020 04:13:38 GMT

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 — Mon, 13 Jan 2020 05:35:10 GMT

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