How can I put a result in a calculation depending on a certain date?

  • Profile Image
    Asked on June 05, 2014 at 04:03 PM

    Hi Team.

    Here's my issue:

    I have A, B, X and Y,

    X = A*B

    Y = X*2

    Z = X or Y depending on the date

    Is it possible to display in Z :

    Z = X If date field before today+3

    Z = Y if date field after today+3

    I tried can't find the right condition to put.

    Can you hepl me guys?

    Thanks a lot


  • Profile Image
    Answered on June 05, 2014 at 04:31 PM

    Sorry I found the answer ;-)

  • Profile Image
    Answered on June 05, 2014 at 06:30 PM


    Glad to hear it.

    Should you need anything else, let us know.

    Cheers! =)