Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Something like this?
=IF(reason_code = 130, SUM({<reason_code = {'130'}>}qty_available) +SUM({<reason_code = {'130'}>}qty_blocked_qc),0)
Hi,
Please try this: if(reason_code = '130', sum($(vInvOnHold)),0)
Something like this?
=IF(reason_code = 130, SUM({<reason_code = {'130'}>}qty_available) +SUM({<reason_code = {'130'}>}qty_blocked_qc),0)
take variable, vShortDate and assign the expression
=sum({$<reason_code={'130'}>}qty_available)+sum({$<reason_code={'130'}>}qty_blocked_qc)