cannot use math in Grid with related columns

I would like to have 2 coltypes with some calculations.
ex : here the c5 column is calculated with values in c4 and c6,
the c6 is calculated with values in c4 and c5

The problem with this code is that it is not possible to edit c4 and c5.
I mean when I edit c4 value, it should recalculate c5 value. And if I edit c5 value, it should recalculate

myGrid= ticket.attachGrid(); myGrid.setImagePath("../includes/js/dx/imgs/"); myGrid.setHeader("c0, c1, c2, c3, c4, c5, c6, c7,c8, c9, c10"); myGrid.setInitWidths("30,100,*,40,70, 55, 70, 80, 40,60,60"); myGrid.setColAlign("center,left,left,center,right,right,right,right,right,center,center"); myGrid.setColTypes("ro,ro,ed,edn,edn,ed[=(c4-c6)/c4],ed[=c4-(c4*c5/100)],ron[=c3*(c4-(c4*c5/100))],ro,coro,coro");

Could you please help me ? :frowning:


try changing coltype from ed to ron as below in your code:-


Thanks !