How to write the below expression

[suvechha_b]

Hi ,

How to write the below expression:

How can I write the below expression:

=(SUM(Aggr( Sum(purchase_receipts), Product,[Product Code],[Product Supplier/Code],[Demand Planner],[Signal/Code] )) - SUM(Aggr( Sum(qty_blocked_qc), Product,[Product Code],[Product Supplier/Code],[Demand Planner],[Signal/Code] ))) * SEP

when select particular product then the total is coming but when selecting all product then the sum is having NULL.

[swuehl · Accepted solution]

In general, use aggregation functions in expressions:

Use Aggregation Functions!

Your SEP field needs to be aggregated, otherwise, an implicte ONLY() function will be applied. If there are more than one value for SEP within the aggregation scope,NULL will be returned from ONLY.

Can't tell which function you need here, maybe Avg(SEP)?