5 Replies Latest reply: Nov 17, 2015 9:41 AM by Nicklas Thorén RSS

    SUM IF Question

    Nicklas Thorén

      Hi everyone,

       

      Trying my very best to figure this one out.

       

      I'd like to make a conditional expression based on the followind.

       

      SALES1=4

      SALES2=4

      ITEMs=3

       

      My expression needs to pre-calculate the following condition, explained as:

       

      If the sum of SALES1 subracted from SALES2 is larger than ZERO, then subract SALES1 from SALES2, multiply by items, divided by 0,8

       

      Trying my best, but in need of help.

       

      Many thanks!

       

      Regards,

       

      Nick