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

(Aparicio Piñeyrúa) #1

Hello!

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

(Philip Garrett) #2

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

You could write something like:

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

(Aparicio Piñeyrúa) #3

@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?

(Philip Garrett) #4

The expression would appear in the body of the template.

(Aparicio Piñeyrúa) #5

@Philip_Garrett_Appsh

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

(Philip Garrett) #6

@Aparicio_Pineyrua1

Try:

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

(Aparicio Piñeyrúa) #7

@Philip_Garrett_Appsh

Thanks a lot! Works perfect