Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
First all deselect the option of "Supress-Zero-Values" from presentation tab.
Then put your requisite condition in below said expression
=if(TRAFFIC_PLACE='FOA',Sum(TOTAL{<Traffic_in={'12'}>}#_NetSales),
Sum(#_NetSales)
)
also find the attached file
Could you share the sample qvw files ?
Yes it worked!!! Thank you very much!
But there is one more thing. In order to have the correct sum in Net Sales,
i have to choose {ΔΕΛΠ ΔΛΠ ΔΛΠ-TF } from the box TR_KIND or else it brings me wrong numbers.
but for TRAFFIC_PLACE] ='FOA i dont have TR_KIND so when i choose the above the FOA is hidden
So what I have to write in the expression in order to fix it!
STOCK |
ΔΕΛΠ |
ΔΛΠ |
ΔΛΠ-TF |
ΠΡΟΚ/ΛΗ |
Good morning!
Can you plz help me with this?
Try this,
=if(TRAFFIC_PLACE='FOA',Sum(TOTAL{<Traffic_in={'12'},TRAFFIC_PLACE=>}#_NetSales),
Sum(#_NetSales)
)