Level 1

0% to

Level 2

Tip /

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

View all

## formcalc calculation with percentage

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

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

Likes

394 likes

Total Posts

2,686 posts

490 solutions
View profile

MVP

Likes

394 likes

Total Posts

2,686 posts

490 solutions
View profile
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