Set Expression

[upaliwije]

Dear Friends

I have written below expression in my pivot table but it returns zero values

sum({<ORDER_QTY={">0"},SUPPLIER=>}STOCK_BALANCE)

Is there any error in it if so pls correct me else pls suggest an alternative solution

Thanks in advance

[Arthur_Fong]

You have a sample app?

[upaliwije]

Yes I attach h/w  my issue is with first column(stock in hand)

[tresesco]

It's not a problem with your expression but data. If you select all ORDER_QTY field values (>0), you would see there is no value associated in STOCK_BALANCE (all values are grayed out). 

[Arthur_Fong]

A better understanding on the post @tresesco has replied, your data is not linked:

 

When order quantity > 0, there is no stock balance to be calculated. Hence expression returned 0.

I guess your data model is done by concatenating both tables together, which in this case not applicable.

You might need to associate using link key or joining both table together, provided each record has a unique key.  

[Brett_Bleess]

Were you able to get things sorted out with help from either of the posters?  If so, do not forget to return to the thread and use the Accept as Solution button to mark the post(s) that helped, you can mark more than one if both were helpful...  If you still need assistance, please leave an update, but please do one or the other, and if you did something different, you can post that and mark that too.

Regards,
Brett