I am stuck and hope someone can help!
Not sure how to explain it so i'll give the example i need.
Invoice #A
Line 1 = CP
Line 2 = NC
Line 3 = UA
Line 4 = IF
Invoice #B
Line 1 = CP
Line 2 = CP
Line 3 = NC
Line 4 = CP
I need a field to call out as so for each invoice and line #
Like - If line 1 = CP then Complete, if NC then Not Complete, if UA then unassigned, if IF then insufficient funds,
ALSO
if line <>1 then call line one from same invoice either Complete, Not Complete, unassigned or insufficient funds.
Basically I need the output from line 1 to populate any following lines for that invoice and reset at the next invoice.
So if line one is complete, all lines need to say complete.
Is this possible?
I know how to get the output through the IIF statement, but not sure on how to make it populate for lines <1
any help is greatly appreciated.
Not sure how to explain it so i'll give the example i need.
Invoice #A
Line 1 = CP
Line 2 = NC
Line 3 = UA
Line 4 = IF
Invoice #B
Line 1 = CP
Line 2 = CP
Line 3 = NC
Line 4 = CP
I need a field to call out as so for each invoice and line #
Like - If line 1 = CP then Complete, if NC then Not Complete, if UA then unassigned, if IF then insufficient funds,
ALSO
if line <>1 then call line one from same invoice either Complete, Not Complete, unassigned or insufficient funds.
Basically I need the output from line 1 to populate any following lines for that invoice and reset at the next invoice.
So if line one is complete, all lines need to say complete.
Is this possible?
I know how to get the output through the IIF statement, but not sure on how to make it populate for lines <1
any help is greatly appreciated.
