Hi,
I have on my Salary condition the following (SB = 35001 or SB > 35001) and (SB = 40000 or SB < 40000)
but the system returns error!!!
Am i doing wrong the formula or i should add another separate condition with only SB = XXX (if this is the case i will have many records …)
Basically because my deduction is base on the SB range to make discount …like this
if (SB >= 35001) and (SB <= 40000) then calculate 1
if (SB >= 45001) and (SB <= 50000) then calculate 2
…
until if (SB > 1000000) then calculate XXXX
Currently i have 13 records or conditions for this and if i cannot do like " (SB >= 45001) and (SB <= 50000) " or like "(SB = 35001 or SB > 35001) and (SB = 40000 or SB < 40000) " my calculations will be wrong.
Any thoughts are most welcome ?