Skip to Content
0
Feb 05, 2020 at 05:02 AM

Merging data from 2 universes

55 Views Last edit Feb 05, 2020 at 05:05 AM 2 rev

Hi All,

i have a requirement as below.

i have 2 queries build from 2 different universes.

Explanation on desired output.

I need to get the "Score" column populated based on comparing Decision date with Received date.

Example: for all the decision dates for 111 customer falling between 14/06/2016 and 27/09/2017, Score should be populated as 100. if the decision date is greater than or equal to 27/09/2017 , then score shoudl be 50.

I have merged based on Customer No.

Could you please help with the login to implement the Score. i am getting #MULTIVALUE error.

Attachments

111.png (11.1 kB)
111.png (12.4 kB)