Unable to do calculate income tax


i have a scenario is calculate taxable income
up to 6,00,000- No tax
from 6,00,000 to 10,00,000- 20% tax rate
above 10,00,000 - 30 % tax rate

example- if taxable income 11,00,000

6,00,000-10,00,000= 4,00,000 *20% =80,000
10,00,000 > 30% mean == 11,00,000-10,00,000=1,00,000 *30%= 30,000

here total taxable income= 80,000+30,000= 1,10,0000

how to do this and write logic?
can any one help me ?

1 Like

we can use SWITCH ACTIVITY where we can condition and based on the output it will go to the cases where we can include the sequnce we want to perform

Cheers @Anand_Designer

1 Like

if my taxable income 11,00,000 ,can you give example in switch activity?

have a look here:


Another solution:

First, create the following dictionary in advance. We can also make it from datatable.

dict = New Dictionary(Of Int32,Double)From{{0,1},{6000000,1.2},{10000000,1.3}}

Then, the following expression will return result value.

yourValue*dict(dict.Keys.Where(Function(i) i<=yourValue).Max)


@Palaniyappan @ppr
i have tried but its not working switch activity .
IncomeTax_Calulation.xaml (8.0 KB)

Hi @Anand_Designer

I slightly changed your code and find it in attachment

IncomeTax_Calulation.xaml (8.1 KB)

Thanks for great help @sai_krishna_somisetty

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.