Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Folks,
How to use if condition around below expression, give me item where below expression value is equal to zero
sum((ACTUAL_COST)*SHIPPED_QUANTITY)
Perhaps this?
sum({<ITEM = {"=Sum(ACTUAL_COST*SHIPPED_QUANTITY)=0"}>} (ACTUAL_COST*SHIPPED_QUANTITY))
Or
Sum(Aggr(sum({<ITEM = {"=Sum(ACTUAL_COST*SHIPPED_QUANTITY)=0"}>} (ACTUAL_COST*SHIPPED_QUANTITY)), ITEM_NUMBER))
Not sure if this will work with yours but you may be able to try a calculated dimension....
In this example if NetSales has a value, the dimension is a space, so all the ones with a value are grouped in a space and for the rest, it shows the item number...
Hey Vish,
I just need show item along with sum of cost where its equals to zero only
Hello Neelam,
Just attached samples, if you see am missing item num 1,4 7 in the QVW file all I need to see is 1,4,7 where cost is equal to zero
Can you give an example of what you are expecting to see for one Item#. Give an example.
In presentation tab of your chart properties uncheck supress 0 values so you can see item numbers 1,4,7. Is that what you are looking for?
I would like to show only items with 0 values in my case, Like below
Try this?
= sum({<ITEM = {"=Sum(ACTUAL_COST*SHIPPED_QUANTITY)=0"} >} ACTUAL_COST*SHIPPED_QUANTITY)
Thanks Vishwa