2 Replies Latest reply on May 23, 2020 1:15 AM by Budi Lubis

    Applying an assumed Revenue by specific date range

    James Vassallo

      Hi,

      So I've got this simple equation of:

       

      revenue = sum(Order Total)*.333

       

      I'm trying to create a calculated field to apply the .333 to a specific date range (2/1-5/18) and then .366 to another date range (5/18 - onwards)

       

      Can you anyone help me with that?