Skip to Content
1
Dec 29, 2022 at 11:02 AM

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

116 Views

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