Dear sir, thanks for your reply, for secound row i use
form1.main.Table1._Row1.addInstance(true); like this. review my screen
shot. script placed in Row3.Cell9 result is also calculate base on first
row. please give me suggestion. thanks
Dear radzmarThanks for your reply, here i attached result screen
shot.which given code is correct. but little modify for percentage
formula. please review this codevar SGST = Sum(Row1[*].Cell10) * 100var
Amount = Sum(Row1[*].Cell7)$ = SGST * Amount / 100but secount row will
not calculate as per this code... this calculate base on first row
percentage value.please review my screen shot.thanks
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)*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.
Dear allHere i attached image for if statement question...give me
sugesstion for this issue.1. GST value only 12% or 18%...so if we enter
value 12% | .12% will be splited in to Table1.Row7.Cell6 and
Table1.Row7.Cell6. it mean each row having 6%...it is a different
state tax...same thing for 18% | .18% (Table1.Row7.Cell6 and
Table1.Row8.Cell6)2. Also GST value multiple by amount and divided by
100 this will be tax amount....and this will reflect Table1.Row7.Cell6
and Table1.Row7.Cell6 sa...