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

    Cannot Mix Aggregate & NonAggregate in IF statements



      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