Skip to Content
0
Former Member
Apr 14, 2010 at 02:17 PM

how can i write this syntax in script logic....

42 Views

hi all

i need to write below syntax in bpc script logic..

If Headcount = 0, then Salary = 0 Else:

[

If Month <> March and Month <> September:

Salary = Salaryprevious month1 + [(Headcountcurrent month - Headcountprevious month1) * (Band Rate + Band Salary Factor)]

If Month = March:

Salary = [Salaryprevious month1 + [(Headcountcurrent month - Headcountprevious month1) * (Band Rate + Band Salary Factor)] ] * (100% + Band Annual Increase + Band Annual Increase Factor)

in the above code headcount,salary,bandrate etc all got ids.

thanks guys