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

    Applying an assumed Revenue by specific date range

    James Vassallo


      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?