Concatenating 3 fields when one field has no value

[jack91]

Hi,

I have 3 fields that i need to concatenate.

Issue:

When one field has *no value but the other 2 fields **have value, and when i concatenate none of the fields which do have value do not show up.

Is there a way to fix this?
I would like to show the fields as

Good/Bad/Ugly -- basically each filed separated by "/"

Thanks
Jk

 

[jack91]

Dunlop1975:

Just to verify:

If there are numbers other than 0, then they would till show up right? it's just that I wanted 0.00 to show as 0 and 4.00 as 4 and so on.
In the actual field there are no decimals , but 'cause we are using totext, it gives decimal values

Thanks
Jk