5 Replies Latest reply on Jul 24, 2018 1:17 PM by Don Wise

    Case or IF statement ???


      i have a scenario:


      if the  any product dose in state is not achieved the sales it should populate as  "Not Consider for Incentive"


      Example: even if a single product missed the target 100% the state should populate "Not Consider for Incentive" . but here i am able to show both on the dashboard. it should be only Not Consider Incentive.


      Eligibility Calculation:

      IF ([Percentage of Achievement]) < 100 THEN ' Not Consider for Incentive' ELSE  "Consider for Incentive" END


      Can some one please look into this issue.



      Thank you