Hello Everyone , Im trying to create similiar case / statement to check PO Status in Report Studio . However , The syntax doesnt work for some reason .
Is there any way we can include this query in report studio ?
if [COMPONENT_BRANCH] = [BRANCH] then
if (([ORDER_QTY] - [ISSUED_QTY] - (
if([ON_HAND] is null) then
0 else
[ON_HAND])))
<= 0 then
“Available”
if [PO_WO_DATE] > [WO_START_DATE] then
"DELAY"
else
"On Track"
else "Check Branch"