Pareto Analysis - Aggr Expression

[#1]

Hello all,

In the image below i want to rank category C for < 0.90 but i still have a Garbage after expression.

The current expression is:

=Aggr( If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.10, 'A',

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.75, 'B',)),

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.90, 'C')),

BrandDescription)

Which changes do i have to make?

Thanks regards,

Rega

[sunny_talwar]

Can you put that expression as a text in the post?

[#3]

=Aggr( If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.10, 'A',

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.75, 'B',)),

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.90, 'C')),


BrandDescription)

[sunny_talwar]

Can you try this:

=Aggr(

     If(

          (Rank(Sum(SalesPrice*TransactionQuantity) ,1) - 1) / Count(distinct total BrandDescription) < 0.10, 'A',

     If(

          (Rank(Sum(SalesPrice*TransactionQuantity), 1) - 1) / Count(distinct total BrandDescription) < 0.75, 'B',

     If(

          (Rank(Sum(SalesPrice*TransactionQuantity), 1) - 1) / Count(distinct total BrandDescription)< 0.90, 'C'))),

BrandDescription)

[syukyo_zhu]

HI,

Try this

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription),1,1)< 0.10, 'A',

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription),1,1)< 0.75, 'B',)),

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)1,1)< 0.90, 'C'))

[Kushal_Chawda · Accepted solution]

Aggr( If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.10, 'A',

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.75, 'B',

If((Rank(Sum(SalesPrice*TransactionQuantity),1)-1) / Count(distinct total BrandDescription)< 0.90, 'C'))),

BrandDescription)

[sunny_talwar]

Kush I am going to ask the OP the same question

How was my response any different from yours?

Rega Sanyoto

[Kushal_Chawda]

regasanyoto‌  As Sunny has responded first with correct answer , you should mark his answer as correct and mine as helpful.

[#9]

Hello Kushal,

How do i  mark his answer correct?

[Kushal_Chawda]

First, unmark mine as correct. And then mark his answer as correct