#MULTIVALUE despite context

[former_member664171]

Hi gurus!!

I am facing a weird issue that I can't get into my mind.

We have a universe based on replicated tables from SAP. We are currently trying to set up a performance supplier KPI based on PO, PO scheduled lines, and material documents. We are using Webi as the rendering tool.

Here is the context. We have a calculation done for "On time"performance based on the required delivery date and the goods receipt date. The concern I have is that in some cases, the goods receipts are cancelled (movement type 103/104), so trying to figure out if the supplier is on time or not starts to be tricky.

That being said, the real concern is that I don't get why Webi does not do the right calculations. When we put in a table :

- PO/scheduled line ([PO / Line Item])

- Material document number ([Material Doc#])

- On time performance

Every line is correclty calculated and the aggregated value for the average is well calculated.

The issue is that I want to have a summary view for the Vendor. So, in another table, I am getting the same ratio, and putting the context aligned to get the right level of details. The formula looks like:

- Average ( Sum([Time Score]) in ([PO / Line Item]; [Material Doc#]))

If I use the formula "Average ([Time Score]) " in the detailed table (ie : a table with [PO / Line Item] , [Material Doc#], [Time Score]), it works ( I am putting the calculation in the header of the table)

But, if I use the context in another table (included into a section on the Vendor ID), then I get a #Multivalue error, taht I don't get....

Any idea why the context would not give the same result as the table...

Thanks for your help

PY

[ayman_salem]

Can you provide screenshots so the community can answer your question?

[former_member664171]

Yes for sure!!

- Average_Detailed is the result I get in a table (regular one). The Average is calculated in the header

- Average_Detailed_Def gives the technical content:

- Average_AGGR gives the aggregated view :

- Average_AGGR_Def gives the technical values:

I had to force the sum for Time Score as I wanted to get the context...