How to make Both table display the same value ?

[paulyeo11]

Hi All

I have Table 1 and Table 2

Expression for Table 1 :-

sum(if(rEVENUE='rEVENUE',Amount/1000))

Expression for Table 2 :-

sum((Amount/1000))

Why when Table 1 and 2 display different value ? Since i have already manually turn on rEVENUE=rEVENUE.

How to make it display the same ?

Paul

[PrashantSangle]

Hi,

use set anlysis in table1 instead of if statement

use below expression in Table1

Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

Regards,

[paulyeo11]

Hi Max

I have try your expression , but the bar never appear.

Paul

[ecolomer · Accepted solution]

see this

[paulyeo11]

Hi Enrigue

I found the issue , it is due to my QVW doc label is 1 REVNUE not rEVENUE.

Thank a lot

Paul