Skip to Content
0
Jul 27, 2020 at 09:50 AM

Business Objects BI Formula Help

36 Views

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