if statement in formcalc or javascript

Avatar

Avatar

akmeeran

Avatar

akmeeran

akmeeran

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.

 

thanks for advance.

 

Untitled-1-01.jpg

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Kosta_Prokopiu1

Employee

Avatar

Kosta_Prokopiu1

Employee

Kosta_Prokopiu1
Employee

22-01-2021

Answers (1)

Answers (1)

Avatar

Avatar

Magus069

MVP

Avatar

Magus069

MVP

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.