Expression

[suvechha_b]

Please help me in the expression :

Screenshot

Short Dated :

I want [Short Dated] as variable , $(vInvOnHold) i.e SUM(qty_available) +SUM(qty_blocked_qc)

when the reason_code=130

or else 0 .

Sample model attached.

[Anonymous]

Hi,

Please try this: ​if(reason_code = '130', sum($(vInvOnHold)),0)

[MK_QSL · Accepted solution]

Something like this?

=IF(reason_code = 130, SUM({<reason_code = {'130'}>}qty_available) +SUM({<reason_code = {'130'}>}qty_blocked_qc),0)

[PradeepReddy]

take variable, vShortDate and assign the expression

=sum({$<reason_code={'130'}>}qty_available)+sum({$<reason_code={'130'}>}qty_blocked_qc)