1 Reply Latest reply on Apr 2, 2012 8:36 AM by Alex Kerin

    Calculated fields using dates and sales

      I need to create a caluclated field that returns to me the sales relative to a certain date.  This needs to be a calculated field because i'm dealing with several other metrics that will not be constrained to this particular date field.

       

      Two particular metrics I need are:

       

      Sales Pre-11/7/2011

      Sales Post-11/7/2011

       

      Can someone help me figure out this calculation?  I'm getting an error that tells me I can't compare datetiem and float values.


      Thanks!