Webi / Bob J MULTIVALUE ERROR create a variable with latest data

[former_member27]

I have a table with PO's and the status and comments. a PO can be more than one time with a status -comment date and time. I'm merging that table with a Universe that has AR data, based on PO. I want to show the PO AR data plus the latest status and comment. Currently, I'm able to display those that only have one instance of data, but for the ones with more than one, I'm getting a Multivalue error. I created a variable that identifies the Max date and the max time and displays the status or a"-" for the rest. But I'm stuck there.

Thank you

status-table-2022-12-28-14-23-05-window.png

multivalue-error-2022-12-28-14-24-15-window.png

[former_member27]

Hi igaleano2,

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get the most out of your community membership, please consider including a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Profile https://developers.sap.com/tutorials/community-profile.html

Tips for Questions: https://community.sap.com/resources/questions-and-answers

Consider taking our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of the SAP Community!

All the best,

Dedi

[former_member27]

Hello again, igaleano2,

I'm glad to see you got an answer to your question! If it helps you, please make sure to accept (you'll see the "accept" option beneath the question) -- so members with similar issues will be able to find a solution to their problems too.

If it doesn't help, you can always leave a comment providing more details that can guide members who wish to assist you.

I hope that this guidance is useful -- and we look forward to your next question for the community!

All the best,

Dedi

[bekart · Accepted solution]

Hi Ivan,

I recreated your issue and below you can find the solution. I see that you have date/time of note/status creation which is necessary to determine the latest note/status. Here I got two universes and the left table is showing only one PO with latest note - that's your expectations.

I had to create a variable [check_date] which is checking and marking the latest comment/note for each PO:

=If([Main PO Progress Creation DateTime]=Max([Main PO Progress Creation DateTime]) In ([Query 1].[Main PO No])) Then 1 Else 0

Next step is merging dimensions ([Purchase Order No] and [Main PO no] in my case.

Then you need to create variable (detail) as below:

=[Main PO Progress Note] Where ([check_date]=1)

And in that way you will achieve what you want as you can see on first screenshot:)

[igaleano2 · Accepted solution]

Thank you for your Help, I did not know how to accept the answer.