Scenario:
A new Expense Code is always assigned to a Type. The Type can either be a Flat Amount or Expense Rate. To find out whether the Expense code created is set to Flat Amount or Expense Rate, we have to create a custom formula to get the right results in reports.

Resolution:
We can create a custom column in Expense detail report with the following formula.

IF((ISNULL(NumberOfUnits))>0,"Flat Rate","Expense Rate")