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 sir, thanks for your quick reply, sorry for delay reply from my
side, you give Exactly what i need . my post added more information..
please review it. thank you very much sir.
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[1].Cell6. it mean each row having 6%...it is a different
state tax...same thing for 18% | .18% (Table1.Row7[2].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[1].Cell6 sa...