8 Replies Latest reply on Mar 4, 2016 9:27 PM by Shinichiro Murakami

    Days to Ship - Sample Super Stores - Multiple Count

    manish.sawjiani

      Hello All

       

      I have created a simple calculated field with the following definition : DATEDIFF("day",[Order Date],[Ship Date]) - But this gives me incorrect values. But if I change the formula with the following definition I get correct values - ATTR(DATEDIFF("day",[Order Date],[Ship Date])). The problem is if I remove the granularity and say add region ( and remove Order ID , Day of Order Date, Day of Ship Date) I would get the '*' and also I am unable to view grand totals for this column. Thanks.

       

       

      Manish