Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Not applicable

## Pareto Analysis - Aggr Expression

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

1 Solution

Accepted Solutions

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
)

13 Replies
MVP

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

Not applicable
Author

=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
)

MVP

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)

Creator III

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'))

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
)

MVP

Kush I am going to ask the OP the same question

How was my response any different from yours?

Rega Sanyoto

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

Not applicable
Author

Hello Kushal,

How do i  mark his answer correct?

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

Community Browser