can I use the attachfooter's value to calculate

Suite and Optimus Suite 5
#1

hello, can I use the attachfooter’s value to calculate. for an example, the fourth column’s value=c3/footer’s value,footer’s value={"#stat_average"} of the third column

#2

You may create your own custom shortcuts with the required logic.
Here you can find the tutorial:
docs.dhtmlx.com/doku.php?id=dhtm … s_creation

#3

Maybe you didn’t understand my meaning. I mean that cells(4,0)=cells(3,0)/sum(c3)
cells(4,1)=cells(3,1)/sum(c3)
cells(4,2)=cells(3,2)/sum(c3)…

#4

Oh, I apologize. :blush:

You may use getFooterLabel() to the value of the footer’s cell
docs.dhtmlx.com/doku.php?id=dhtm … ooterlabel

But in that case you will have to build your own custom math as the default math functionality doesn’t allow to use footer values but only the values of the cells.

#5

I have solve it. Thank you!