Forum Discussion

Nun's avatar
Nun
Resolver I
1 year ago

Calculate average price based on certain condition

I have this table,  Agent PZ EUR/pz A 100 280   50 275 C 220 260 D 130 258 E 300 255 F 500 253 G 80 252 H 20 240 I 300 239 J 700 238 K ...
Need Help
Nun's avatar
Nun
Resolver I
1 year ago

HI Anonymous , thanks so much for supporting, I really appreciate it!
I created the Ranked Table, then I tryed to create the table (Top10Pcttbale)  to calculate Cumulative PZ and Filter for Top 10%, but I can't because I get this error:"The first argument of EARLIER/EARLIEST is not a valid column reference in the earlier row context.". Then I created the measure to calculate Weighted Avg Price for Top 10% PZ. But I do not understand the relationship between the three functions. My final aim is to determine the average price of the prices that have a quantity of 10% of the total, for a given period, for a selected product. In the attached tables, the top price 273.28 is the average price of product X for the first quarter, for the total of products that are equal to 10% of the overall total

Nun's avatar
Nun
Resolver I
1 year ago

Hi, yes you are right, my apologies. But that 

Top10PctTable

 is not taking in consideration the "remaining PZ", right?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Nun ,

     

    Yes, it won’t include the remaining PZ because we’re explicitly specifying the top 10 PZ, so those others won’t be considered.

     

    Thank you.