different values in KPI and bar chart

[wlpike]

Hi,

i ran into strange discrepancy concerning sales of a product displayed in a bar chart and a KPI field.

when displaying the sales value in KPI using following expression:

sum(anz24W)

its the correct sales sum of this product

when displaying the sales value in a chart using following expression:

 if(PRDCTH0CS = 'GO',sum(anz24W),
 sum(SALES_1R1)
)

 its showing somehow a false value and i don't know why.

could it be due that i want to change the sales data for "GO" ? At least that is the only difference between the two calculations...

Measure "anz24W" is a calculation imported from a QVD file.

thanks!

br

Chris

[agni_gold]

KPI box is showing data for all PRDCTH0CS ,
while in another expression you are summing data only for GO.

And if SALES_1R1 and anz24W columns should have the same total, then you have to check your data.

[wlpike]

in the if clause i want to overwrite data of "GO", so this should be okay, but the sum is different in KPI and chart (if clause)

the expression is the same in both charts -> sum(anz24W)

as it seems, the sum of "GO" is not overwritten totally, so what could be done here in the background.