Sum function on export CSV data.

No magic formula for that.

There is a SumField transform, but that outputs the sum but not the data. It’s not going to give you the data with a sum row at the bottom.

Ok tanks for your respond. Have you a solution for me with this issue… i need an export data with a bottom sum field. Other solution, custom developpment… ?

Tanks
Damien

Ok. I wrote a transform and added it to version 2.9.12 which I am releasing now.

See: SummationRow

Hi Michael,

Tanks a lot for this solution it’s work fine !

Always for the same project a last thing I need to know if it’s possible to give a determinate place for the different “submit login” people.

Tanks a lot
Damien

You can use “tfilter” just like “filter” but “tfilter” happens before the transform (SummationRow).

Ok, for made simple, if i write :

tfilter=”Submitted Login=test0″ it’s ok “test0” display ok, but if i write tfilter=”Submitted Login=test0,test1,test2″doens’t work. Witch code put to have test0,test1,test0 in order in my Submitted Login column ?

Tanks
Damien

Submitted Login=test0||Submitted Login=test1||Submitted Login=test2

filter show the three differents Submitted Login, but not in the order that i want by row. it show :

test2
test0
test1

I need to see :

test0
test1
test2

or the order that i want…

Tanks
Damien

I am confused. I thought you were asking to filter out certain values. Now I think you are asking to order the values.

If you want to order the rows by a certain column use torder="column-name"

Don’t use tfilter unless you wish to limit the results to just rows that match it.

Hi,

torder=”column-name”, nothing happens… with orderby=”Submitted Login” it reorganize the column, but not like i want.

My code is :

[cfdb-table form=”form1″ show=”Submitted Login,Repas-primaire,Repas-adulte,Repas-maternelle,Potages” torder=”” trans=”SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”]

I need to reorder the rows by login like i want in Submitted Login column.

Tanks
Damien

torderby=”Submitted Login”

i already try it but it reorganize Submit Login by first Submit Date, but not like rows that i want… i’m deseperate.

Tanks
Damien

Post the full shortcode

[cfdb-table form=”form1″ headers=”Submitted Login=écoles” show=”Submitted Login,Repas-primaire,Repas-adulte,Repas-maternelle,Potages” torderby=”Submitted Login” trans=”SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”]

Nothing other
Tanks

Ok, I see that is not sorting as expected. Try this:

[cfdb-table form=”form1″ headers=”Submitted Login=écoles” show=”Submitted Login,Repas-primaire,Repas-adulte,Repas-maternelle,Potages” trans=”NaturalSortByField(age)&&SummationRow(Repas-primaire,Repas-adulte,Repas-maternelle,Potages)”]

instead of tordery, I added NaturalSortByField to the transform.