Sign in to Community
Sign in to view all badges
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)*100sum ($.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.
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