I am trying to add a step in my workflow to do validation on GST.
Sometimes there are multiple tax Code in the header. But this example only has one.
I am trying to use Advanced Math to calculation a value called _zeroGST, but it kept giving me errors.
Anyone familiar with ECM workflow? Basically, I want to check each of the HeaderTaxes Row to see if there is any line that is 0.
Fortunately, you won’t need to convert the inputs like you’ve done. Try this:
IIF('{0}=‘GST’ AND 0{1} = 0,1,0)
The leading 0 in 0{1} helps mitigate issues where the value may be blank (null).
This will also check for null values.
IIF(ISNULL({0}, “”) = “GST” AND ISNULL({1}, 0) = 0, 1, 0)
Hi, @TobyLai. Did either Anthony’s or my solution provide you what you needed to get things working?
