Conditional Formating

[YANKRAY]

Crystal Reports 10.0

I have a formula that produces this output in the details section;

75.95
11.57

This formula is based on using an alias table and an if null condition. If the field is null in Table1 then select the amount in Table1A else the amount in Table1.

My issue is that the 75.95 are $dollars and the 11.57 is a percent%.

I can use the same isnull formula to produce this output

75.95
0.12

I can use an if >1 condition to identify the number, but how do I write the conditional format to to show a result like this?

$75.95
11.57%

Ray

 

[Turkbear]

Hi,
So I understand correctly:
The same field can be either a % or $ amount?

But,if Table1 has $ and Table1A has % ( or vice-versa )then testing for which table the data is from should let you create a conditional format formula.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[YANKRAY]

That is correct.

I do not know how to write the "then" condition itself.

For example: how do you write that the format should be the $ on the left or the % on the right?