Skip to Content
Former Member
Dec 12, 2013 at 07:45 AM

Measure giving incorrect values


Hie Guys,

I have created a combined report from 2 universes. I merged all the common dimensions. I used the below formula for the combined measure object - If (IsNull (Measure from Universe 1) Then Measure Variable from Universe 2 Else Measure from Universe 1. I got correct values for Universe 1. But, for Universe 2, I am getting values that are more than expected (incorrect). I'm not sure why it is pulling those incorrect values. I've attached the snapshots below for the measure variable from Universe 2 and the combined measure variable for both universes below. Any idea on what could be the issue? Thanks.