set analysis formula

[fabricecallegar]

Hi,

I need your help to create a fromula.

I have this data :

I want to know how many distinct tickets available by attribut with the special condition : if the sum of qty by ticket must be different than 0, else the ticket is not taken.

So the results must be :

A1 : 1 (ticket T2)

A2 : 2 (ticket T1 and T2)

In fact, I want the sum of the third column by attributs :

and when I remove "Tick" the results are false;

Any ideas ?

[robert_mika]

So in your last example the last two 1  (under if(sum(Qty)...will be evaluated to 0?

[jagan]

Hi,

Try this expression using Aggr()

Sum(Aggr(If(Sum(Qty) = 0, 0, 1), Tick))

Hope this helps you.

Regards,

Jagan.

[fabricecallegar]

no, I would like to have :

A1 : 1

A2 : 2

[fabricecallegar]

thank you Jagan but it doesn't work :

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

I used this expression, it is working.

=Sum(Aggr(If(Sum(qty) = 0, 0, 1), tick, attribute))

Regards,

Jagan.

[maxgro]

=count(distinct Aggr(If(Sum(q)=0, null(), t), t, a))

[fabricecallegar]

thank a lot !

[#9]

Hi Fabrice.

please see attached, another option for you which doesn't require nesting an if statement.

Hope that helps

Joe