10 Replies Latest reply: Nov 8, 2011 8:47 AM by swuehl RSS

    why is Date2-Date1 and sum(Date2-Date1) different

    Syed Shah



      I have a chart where I have three dimensions


      Resource     Start Date      End Date



      No row is repeating for these three dimensions. Then i am just checking a few expressions and i have noticed something strange. When i take the expression (End Date - Start Date), it is giving the correct date different. However, when i take sum(End Date - Start Date), The value becomes really huge


      I think that if no row is repeating for these three dimensions, then the sum should not make any difference over (End Date - Start Date)


      I have created a sample data with five rows, and on that sample data, the sum is not making any difference, which makes sense. However, on real date, the sum is changing the results.


      the below image shows when i am simple taking the data difference (End - Start)




      The below image shows when i am taking sum over difference .i.e sum(end - start)


      sum over difference.PNG


      Can someone see what might be wrong with my data or expression?