10 Replies Latest reply on Jun 21, 2018 5:35 PM by Shinichiro Murakami

    Cannot Mix Aggregate & NonAggregate in IF statements

    NAYANA MADHEKAR

      Hello..

      Need urgent help.

       

      I have a dummy set here for you..

       

      I am having errors when I do sum calculations in IF Statement..

      The calculations are wrong when I try it to do the other way,... I have named the calculation so should be self explanatory..

       

      If somebody could please help..

       

      The calculation for Net Sales/H should be.. If East then 14.

                                                                           If West then 5.

       

      Thank you..

       

      Looking forward to hear  as soon as possible. Please