If Number blank display text field else number 1

[Pete271]

Hi

I need a formula which uses to tables, the problem I'm having is that the tables are of different data types.

If numeric.table equals 0.00 then text.table
else numeric.table

I'm sure this is straight forward but I just can't crack it.

Many thanks
Pete

 

[Madawc]

If numeric.table equals 0.00 then text.table
else ToText(numeric.table)

ToText can also control decimal places and do fancy formatting for dates. Worth looking up on [Help].

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Pete271]

excellent! it was the brackets around numeric.table that I was missing.

thanks again
Pete