Skip to Content
0
Jun 06, 2018 at 08:50 AM

Need help on WebI report

72 Views

Hi,

Need help to achieve below output in WebI.

Query A

Query B

Expected Output:

My requirement to pick Target from Query B based on Sales Date from Query A, where Sales Date falls between Start Date and End Date.

Common object : User Id

have tried this formula but getting multivalue error.

=[Target] where ([Sales Date] between ([Start Date];[End Date]))

Thanks in advance!

Attachments

table-1.png (4.2 kB)
table-1.png (4.2 kB)
table-2.png (7.1 kB)
output.png (4.9 kB)