Hi there
I have a data set, (an example below)
What I want to to is to say that if a row has zero, i would like it to return the column header. However, I have a lot of columns if which i need to do this. Is there an easy way to do this rather than using an IIF function for each colum ?
Kind regards
Solved! Go to Solution.
Hi @ohruud,
You could use a multi-field formula to solve this:
IF ToString([_CurrentField_]) = '0'
THEN [_CurrentFieldName_]
ELSE [_CurrentField_]
ENDIF
Input:
Output:
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
Thanks, that helped:)