Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
davidoxi
Contributor III
Contributor III

calculated field sum

I want to sum the general total of calculation field :

table.png

6 Replies
sunny_talwar

This seems like a straight table, try to set total mode to sum on the expression tab for NB Commande_Stock expression

davidoxi
Contributor III
Contributor III
Author

I want to sum up

table.png

sunny_talwar

What are the expressions you are using? Would you be able to share a sample?

davidoxi
Contributor III
Contributor III
Author

Somme_LN_UrgentT /(Somme LN_Stock +Somme_LN_URGAENT )

sunny_talwar

Other two expressions?

davidoxi
Contributor III
Contributor III
Author

Somme LN_Urgent  = sum(Aggr(count(if(match([Type de commande], 'URGENT','GROS', 'PVI')>0, [N° ligne])),[N° donneur d'ordre])) ;

Somme LN_Stock = sum(Aggr(count(if(match([Type de commande],'STOCK','PROMO')>0, [N° ligne])),[N° donneur d'ordre]))