Return coulmn header to rows with 0

[ohruud]

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

[Jonathan-Sherman · Accepted 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

[ohruud]

Thanks, that helped:)