Create a calculated field Like below
IF ISNULL(Invoice PO Doc Number ) or
ISNULL(SC Doc Number)
use this calculation --> Place it in color --> Select the suitable visualization from show me --> Flag color helps to identify the PO which have missing
Invoice PO Doc Number or SC Doc Number
hope this helps
Plz mark this answer as correct or helpful to close the thread
I have added in the calculated field, but everything is flagged out instead.
Any idea what did I do wrongly? I have attached the packaged workbook.
Thanks for your help!
Completeness Test.twbx 19.4 MB