Hello! How can I show blanck spaces in a rep...

[Aparicio_Pineyr]

Hello!

How can I show blanck spaces in a report if the value in the table =“0” or the cell is blank?

[Phil]

Your workflow templates can contain IF expressions to control what value you display.

You could write something like:

<<IF([MyField]=0,"",[MyField])>>

[Aparicio_Pineyr]

@Philip_Garrett_Appsh

I add that formula inside the cell of one of the columns inside the template table? or inside the formula at the begining of the template table?

[Phil]

The expression would appear in the body of the template.

[Aparicio_Pineyr]

@Philip_Garrett_Appsh

I add it : <<IF([F12]=0,"",[F12])>> But for some reason is not working. Does this works with virtual columns?

[Phil]

@Aparicio_Pineyrua1

Try:

Virtual: <<IF([Virtual]=0,””,CONCATENATE([Virtual]))>>

[Aparicio_Pineyr]

@Philip_Garrett_Appsh

Thanks a lot! Works perfect