7 Replies Latest reply on Sep 21, 2018 7:28 AM by meenu choudhary

    Conditional arithmetic calculations

    Mitchell Hensman

      Dear Community,

       

      I'm stuck on subtracting two values (in my current case a date difference). The challenge is that they are dates in the same field and I'd like to subtract them based on a value in another field.

       

      I put together a rough illustration of the situation:

       

      For example, subtracting the shipping date for Consumer from the shipping date for Corporate. Is there a way to do such a thing?

       

      Thanks,

       

      Mitchell