Hi everyone,
So in my report I have two types of receivers, one from the main universe which is a dimension. Another receiver that’s a result from a detail, so a different universe. They’re seperated in the report and I’d like to combine them, I tried the formula:
=If [Receiver(dimension)] ="" Then [Receiver(detail)] Else [Receiver(dimension)]
But this returned NULL for the dimension receiver…
Same thing for combining data from two detail variables.
Situation explained below:
Thank you for your time,
Kind regards
Since you are combining data from 2 queries, you need to merge the dimensions. You’ll need to create a variable to turn Receiver Detail into a dimension (you can’t merge a dimension with a detail), then merge Receiver Dimension and Receiver Dimension Variable. Using the resulting merged receiver dimension in your report will combine the values into a single list.
1 Like
Hi, the fix was way easier than imagined… It was literally =[Vendor (detail)]+[Vendor (detail2)]
Be VERY careful combining data like that without properly merging your dimensions