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?