6 Replies Latest reply on Nov 29, 2016 9:40 AM by stel.chiotis

    Value to specific dates - cannot mix aggregate and non-aggregate arguments

    stel.chiotis

      Hi,

       

      I am after a calculation that returns the value specific to the days mentions below.

      - Yesterday

      - 7 days ago

       

      I have [Openning Date] and number of [tickets] but the calculation says it 'Cannot mix aggregate and non-aggregate arguments'

      sampletickets.JPG

      Any ideas please?

       

      Thanks.