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)
Try this?
= sum({<ITEM = {"=Sum(ACTUAL_COST*SHIPPED_QUANTITY)=0"} >} ACTUAL_COST*SHIPPED_QUANTITY)
It should go something like this:
IF(sum((ACTUAL_COST)*SHIPPED_QUANTITY)=0,true expression, false expression)
I need values in Straight table, Not working
Do you have a sample qvw you can share?
Sorry I dont have any sample QVW but you see below I want to show only rows with zero value
Try this?
sum(IF(ACTUAL_COST*SHIPPED_QUANTITY = 0, Fieldused1, 0)
Not sure which field you want to sum on so just mentioned some dummy name. Replace that with your actual fieldname.
Hello Vishwa,
It gave odd results
I don't think you should sum a dimension like ITEM_NUMBER. It would be easier to understand if you can provide a sample file with expected output.
You cannot do a sum on your ItemNumber. Itemnumber is not a measure value right? may be you need count. Use count instead of Sum.
Are you trying to count the number of items or you want sum(cost) ?