Dear sir, Which i apply calculation script on row3....thanks

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...

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...

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 sir, thanks for your quick reply,,,sorry for my delay reply Exacatly what i am looking

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% |...