How can I calculate professional tax by formula or condition?

[CodeOne]

I tried to put the formula but it doesn’t work. If anyone has a solution, then guide me.

[CodeOne]

Yes I tried but it only executes the first and second conditions not the third condition.

[centaur]

Hi @CodeOne

Your formula is wrong because the third condition cannot be satisfied !!

base < 9000 is 80

base >= 9000 is 150

the 3rd condition will not be satisfied because of the above 2 !!

[NCP]

Hi @CodeOne,

Please apply it and check.
for example.

1800 if (B / total_working_days) * payment_days > 15000 else 900 if 12000 < (B / total_working_days) * payment_days < 15000 else 500 if 9000 < (B / total_working_days) * payment_days < 12000 else 0

Reference:

Multiple conditions on Salary Structure with a single formula

This worked for me: frappe@ubuntu:~/frappe-bench$ bench console In [1]: base = 5001 In [2]: base * 0.01 if (base >= 5000 and <= 10000) else base * 0.02 if (base >= 10001 and <= 15000) else 0 File “”, line 1 base * 0.01 if (base >= 5000 and <= 10000) else base * 0.02 if (base >= 10001 and <= 15000) else 0 ^ SyntaxError: invalid syntax In [3]: base * 0.01 if (base >= 5000 and base <= 10000) else base * 0.02 if (base >= 10001 and base <= 15000) else 0 Out[3]: 50.01

Please set your condition according to you.

Thank You!