If Condition

[dseelam]

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)

[lfholland]

It should go something like this:

IF(sum((ACTUAL_COST)*SHIPPED_QUANTITY)=0,true expression, false expression)

[dseelam]

I need values in Straight table, Not working

[lfholland]

Do you have a sample qvw you can share?

[dseelam]

Sorry I dont have any sample QVW but you see below I want to show only rows with zero value

[vishsaggi]

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.

[dseelam]

Hello Vishwa,

It gave odd results

[neelamsaroha157]

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.

[vishsaggi]

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.

[vishsaggi]

Are you trying to count the number of items or you want sum(cost) ?