## formcalc calculation with percentage

akmeeran

Total Posts

7

Likes

0

0

akmeeran

Total Posts

7

Likes

0

0
akmeeran

06-01-2021

Dear all

Just i try to do formcalc....basically GST percentage multiply by  Amount and divided by 100....for example my input percentage .15%. not 15%...if i apply like this

\$.rawValue = (Row1[*].Cell9)*100
sum (\$.rawValue*Row1[*].Cell7/100)

this formula will work only first row....it mean formula will not calculate all rows values. plesae give me some suggestion....thanks for your support.

View Entire Topic

MVP

Total Posts

2.7K

Likes

392

488

MVP

Total Posts

2.7K

Likes

392

488
MVP

08-01-2021

The line \$.rawValue = (Row1[*].Cell9)*100 makes no sense, what are the brackes for?

If a refered field is in the same row, you don't need to reference the row.

\$ = Cell9 * 100

To reference all instances of the field in every row use the sum() method

\$ = Sum(Row1[*].Cell9) * 100

To calculate a subtotals use variables.

var SubTotal1 = Sum(Row1[*].Cell9) * 100

var SubTotal2 = Sum(Row1[*].Cell7) * 100

\$ = SubTotal1 * SubTotal2