1 Reply Latest reply on Dec 4, 2018 5:30 AM by Jim Dehner

    Calculated Column is returning blank values

    Calvin Pinto

      Hi Guys,

      I'm trying to calculate the Weighted average for yesterday and last seven days from Yesterday.  my calculation is valid but still it isnt showing up any value.

       

      For Yesterday weight average i have a created calculated field :

       

      IF ATTR([Day.of.Actual.Order.Date]) = TODAY()-1

      then SUM([Quantity]*[Duration])/SUM([Duration])

      END

       

      Case2: For Past seven days of weight average

      For Yesterday weight average I have a created calculated field :

       

      IF ATTR([Day.of.Actual.Order.Date]) <= TODAY()-2 AND

      ATTR([Day.of.Actual.Order.Date]) > TODAY() - 8

      THEN SUM([Quantity]*[Duration])/SUM([Quantity])

      END.