Forum Discussion

Nun's avatar
Nun
Icon for Resolver I rankResolver 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
Icon for Resolver I rankResolver I
1 year ago

Hello,
thanks a lot! Here a table consider that PZ is sum of Pz (measure) and EUR/PZ is a measure too.I should get 

 

CustomerDelivery customerPZEUR/pz
AAA4,631296,6076441
ABB4,104291,4205653
ACC23,39286,9392903
ACC4,961282,9953638
A…5,623282,4399787
A 10,254278,0856251
A 18,298277,7456553
A 15,877277,1902752
A 5,623276,6548106
A 15,388276,4121393
A 6,899276,2095956
A 10,915274,5112231
A 14,16273,9413842
A 11,867271,0878908
A 9,922268,8218101
A 17,522268,3449378
B 26,46266,9780801
C 40,684266,795792
A 5,292266,7611489
A 9,592264,8415346
A 18,524264,3462535
A 9,592264,2003753
A 21,5263,992093
D 172,329263,9917251
A 21,791262,3950255
A 9,262259,0671561
A 5,623257,5866975
A 74,689257,2599713
A 9,922255,1330377
A 42,338255
A 491,009254,8750023
…. 16,207252,7210465
  19,912252,5271193
  228,743249,5453413
  50,548248,844069
  90,31245,6905105
  134,544245,2783476
  9,016243,5337178
  259,57242,9669453
  16,207241,8905411
  18,705240,7399091
  127,008238,1796422
  37,008237,6513186
  58,579237,2280169
  43,332236,7659005
  54,874233,3671684
  5,954232,8249916
  41,636232,3311557
  40,683232,3184131
  4,631230,969553
  23,816230,5710447
  43,324229,251685
  37,231227,5069163
  55,441226,3701953
  4,874224,3906442
  29,108222,9359626
  93,878222,7130957
  9,592220,6380317
  5,954215,6415855
  85,931214,1419278
  54,104173,5557445
Total 2838,761