Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.