I am trying to put a formula into Business Objects however it keeps bringing up errors.
I am trying to say if its fixed put a 0 in the rate total however if hourly then leave how it is. Below is teh formula I have so far, any light/help would be appricated.
=if([Weekly Staff Rota by Club].[Fixed or Hourly:Roster Costs]="Fixed") then[Rate Total] 0 Elseif([Weekly Staff Rota by Club].[Fixed or Hourly:Roster Costs])