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

    Case or IF statement ???

    Amyl

      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