Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

## if statement in formcalc or javascript

akmeeran
Level 1

Likes

0 likes

Total Posts

7 posts

0 solutions
View profile

akmeeran
Level 1

Likes

0 likes

Total Posts

7 posts

0 solutions
View profile
akmeeran
Level 1

28-12-2020

Dear all

Here i attached image for if statement question...give me sugesstion for this issue.

1. GST value only 12% or 18%...so if we enter value 12% | .12% will be splited in to Table1.Row7.Cell6 and Table1.Row7[1].Cell6. it mean each row having 6%...it is a different state tax...same thing for 18% | .18% (Table1.Row7[2].Cell6 and Table1.Row8.Cell6)

2. Also GST value multiple by amount and divided by 100 this will be tax amount....and  this will reflect Table1.Row7.Cell6 and Table1.Row7[1].Cell6 same thing for 18% | .18% (Table1.Row7[2].Cell6 and Table1.Row8.Cell6)

3. Row maybe extended 8 or 10 rows....so need calculation for all rows.

#### Accepted Solutions (1)

Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

310 posts

87 solutions
View profile

Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

310 posts

87 solutions
View profile
Kosta_Prokopiu1
Employee

22-01-2021

Magus069
MVP

Likes

143 likes

Total Posts

1,072 posts

155 solutions
View profile

Magus069
MVP

Likes

143 likes

Total Posts

1,072 posts

155 solutions
View profile
Magus069
MVP

29-12-2020

Hi there,

There is not much details of what you are trying to accomplish here, based on what you have provided, here is how I would achieve this.

In the calculate event of the field Table1.Row7[0].Cell6 you would enter the following syntax:

``````//intPercentage should be the reference syntax that can retrieve the value up above.
var intPercentage = Table1.Row1.Cell6.rawValue;
//Cell5 or Cell6... it is not really obvious which field you are using.
if (intPercentage == 12 || intPercentage == 0.12){
//12 or 0.12 depends if you have to enter "0.12" to be able to display 12% in the field
this.rawValue = intPercentage / 2;
} else {
this.rawValue = 0;//or null if you wish
}``````

And you would do the same thing for the next field Table1.Row7[2].Cell6 calculate event but use the 18 value.

If this is not doing exactly what you wish, please provide more details.