IF AGGR COUNT

[Anonymous]

Hello, I would like to have the turnover of customers having 2 orders over a period.

But my formula does not work.

My order count is good

Nb of order : count( DISTINCT{<[Date Commande]={">=$(=vDateDébutAnnéeN) <=$(=vDateFinSeg)"}>} [N° Cde])

but not formula  :

Turnerover for 2 orders= If(   Aggr(count( DISTINCT{<[Date Commande]={">=$(=vDateDébutAnnéeN) <=$(=vDateFinSeg)"}>} [N° Cde]), [Code Client])=2

,[Ca Produit HT])

I need to aggr because in the end i need only one figure that will be the sum of all these clients

thanks for your help

[ali_hijazi]

sum(aggr(count(distinct.....),[code client]))

[sunny_talwar]

Are you using this as your calculated dimension or is this an expression?

Turnerover for 2 orders = If(  Aggr(count( DISTINCT{<[Date Commande]={">=$(=vDateDébutAnnéeN) <=$(=vDateFinSeg)"}>} [N° Cde]), [Code Client]) = 2, [Ca Produit HT])

[YoussefBelloum]

If(   sum(Aggr(count( DISTINCT{<[Date Commande]={">=$(=vDateDébutAnnéeN) <=$(=vDateFinSeg)"}>} [N° Cde]), [Code Client]))=2

,sum([Ca Produit HT]))

[Anonymous]

this is an expression

thanks

[Anonymous]

thanks but how to get afterwards only the sum of all this in a single expression?

[stabben23]

then you need to "wrap" a sum around the Expression.

sum(If(   sum(Aggr(count( DISTINCT{<[Date Commande]={">=$(=vDateDébutAnnéeN) <=$(=vDateFinSeg)"}>} [N° Cde]), [Code Client]))=2

,([Ca Produit HT])))

[Anonymous]

sorry it doesn't work

[YoussefBelloum]

here it is a single expression which will give the result you want, did you try it ?

[sunny_talwar · Accepted solution]

May be this

Sum({<[Code Client] = {"=Count(DISTINCT {<[Date Commande]={"">=$(=vDateDébutAnnéeN) <=$(=vDateFinSeg)""}>} [N° Cde]) = 2"}>} [Ca Produit HT])