Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Key | EAP Number | Description | Flag | CDM_Unit_Price | Key1 | WeightedAverage | CPT Code |
48.815326373101 | |||||||
RC112 | 112 | AV | RC | 217 | RC|96372 | 0.064323455088445 | 96372 |
ROPH112 | 112 | AB | CA | 124 | ROPH96372 | 17.043596508616 | 96372 |
RUH112 | 112 | CD | CA | 123.94 | RUH96372 | 36.381438588074 | 96372 |
RC23 | 23 | BG | RC | 217 | RC|96372 | 48.333502366464 | 96372 |
ROPH23 | 23 | BH | CA | 124 | ROPH96372 | 22.828434560022 | 96372 |
RUH23 | 23 | GH | CA | 123.94 | RUH96372 | 50.019778552919 | 96372 |
Here we have calculated weighted Average based on Key.
then again we have to show the weigted average grouped by Key1
output should be like: Only a single row item based on Key1.
how to do please suggest.
Key | EAP Number | Description | Flag | CDM_Unit_Price | Key1 | WeightedAverage | CPT Code |
48.815326373101 | |||||||
RC112 | 112 | AV | RC | 217 | RC|96372 | 0.064323455088445 | 96372 |
ROPH112 | 112 | AB | CA | 124 | ROPH96372 | 17.043596508616 | 96372 |
RUH112 | 112 | CD | CA | 123.94 | RUH96372 | 36.381438588074 | 96372 |
@agarwal16 Did it solve your problem? please mark accordingly.
=ONLY(AGGR(MIN(WeightedAverage),Key1))
@agarwal16 Did it solve your problem? please mark accordingly.