Business Objects BI Formula Help

[former_member697641]

Hi,

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])

Thanks

[ayman_salem · Accepted solution]

your Variable "Rate Total" formula should be:

Rate Total: =if([Weekly Staff Rota by Club].[Fixed or Hourly:Roster Costs]="Fixed") then 0 Else([Weekly Staff Rota by Club].[Fixed or Hourly:Roster Costs])

[former_member697641]

Perfect! Thank you 🙂