Skip to Content
0
Former Member
Jan 18, 2017 at 08:15 PM

SEM BPS If condition in formula

56 Views

Hi,

I have a scenario where I need a conditional statement with IF.ENDIF. which satisfies the below criteria.

Statement1 has to be executed for all the Cost centers excluding a range of cost centers which are (M100 to M900) and Cost center M940.

I need the correct syntax for FOX formula which satisfies above condition.

I realised that between relational operator does not work.

Thanks

vas