Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am taking this logic from an expression I am using, pulled out the parts that are unnecessary for a script and now need to convert it to a script. How do I do that?
if(
(Sum({$<SO_Closed={1}, DateKey={"<=$(vMax_SO_Closed_GlobalDateNum)>$(=vMax_SO_Closed_GlobalDateNum-DaysTillDead)"}} [Actual Quantity])=0)
AND
sum([Case qty on hand])<>0
,
True
)
vMax_SO_Closed_GlobalDateNum is today's date. How would I get this logic in a script?
This can be done, But why you want to use this in script instead UI?
Because I then want to use this flag in another report to show all customers who purchased these items AND only show those items. I can easily put the flag in the set analysis to achieve this end.