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.
Is the second row also named Row1? If not, the script won't work there, since Row1[*] resolves all instances of an element named Row1. In what field do you place the calcuation script?
Thanks for your reply, here i attached result screen shot.which given code is correct. but little modify for percentage formula. please review this code
var SGST = Sum(Row1[*].Cell10) * 100var Amount = Sum(Row1[*].Cell7)$ = SGST * Amount / 100
but secount row will not calculate as per this code... this calculate base on first row percentage value.please review my screen shot.
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