formcalc calculation with percentage

Avatar

Avatar

akmeeran

Avatar

akmeeran

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.

Untitled-1.jpg

View Entire Topic

Avatar

Avatar

radzmar

MVP

Avatar

radzmar

MVP

radzmar
MVP

08-01-2021

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?