1 Reply Latest reply: Dec 7, 2010 5:33 AM by alxtoth RSS

    Summary level data giving wrong result

      Hi,

       

      while displaying date in flat table output is fine

      But when it is summed up then total is not matching.

       

       



      Code used in flat table

       

      (

      if(

      [Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup)

      ,(

      if([Employment WET]<=vMonthEnd,[Employment WET]+1,vMonthEnd)-

      if([Employment WEF]<=vMonthStart,vMonthStart,[Employment WEF]))/(vMonthEnd-vMonthStart)

      )

      )

       

      Code used at summary level

       

      sum(distinct

      if(

      [Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup),

      ( if([Employment WET]<=vMonthEnd,[Employment WET]+1,vMonthEnd)

      -

      if([Employment WEF]<=vMonthStart,vMonthStart,[Employment WEF])

      )

      ,0)

      )

      /

       

      sum(distinct

      if(

      [Employment WET]>=vMonthStart and Designation<>'Partner' and IsText(Descipline_Utilization) and IsText(Discipline_Utilization_MainGroup),

      (

      (vMonthEnd-vMonthStart)),0

      )

      )

       

      Thanks

      Nishant