IF Then Else Issue

[wanzek]

I am working on a report for our equipment. The report has the name of the unit and I want to put the rate but I cannot get the rate to work correctly. We have a category rate that defaults for each unit unless it is overridden with a specific rate. This is my formula as of now but it has some bugs:

If isnull ({Specific Rate}) then ({Category Rate}) Else
If ({Specific Rate})<>({Category Rate})
Then ({Specific Rate})
Else ({Category Rate})

However, this formula does not work correctly.

 

[fisheromacse]

How is it not working correctly?

Can you show a sample of the data, then an example of how the sample data currently appears, and last an example of how you would like the sample data to appear.


For my ease of reading, I rewrote your formula:

If isnull({Specific Rate}) then {Category Rate} Else
(
If ({Specific Rate}<>{Category Rate})
Then {Specific Rate}
Else {Category Rate}
)