MergeFields with Switches, is there a switch to backspace?

[wattl]

Is there a switch that lets you backspace when using MergeFields. For
example, I have a number pulls in 789789.0. I would like for it to
automatically backspace and get rid of the .0. There is no way in the base
system to change the format of this number.

Thank you,
LW

 

[Greg Maxey]

I don't think so. You could try a conditional field. Replace "REF Test"
with your mergefield value.

{ IF { =({ REF Test }-{ =INT({ REF Test }) }) } = "0" "{ REF Test \# ",0" }"
"{ REF Test \# "0.0" }" }

 

[wattl]

Greg,

Thank you for the information but it did not work. I will do some more
research to see why it did not work. Looks like it should have.

Lisa

 

[Greg]

Lisa,

I don't have a merge document to test with. The field construction
works here when tested using a REF field. Can you get it to work using
a REF field?

The format switches ",##0" and ",##0.##" may be better suited to your
needs.