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

• ###### 1. Re: Case or IF statement ???

HI Amyl,

Use the below calculation

IF

{fixed statename : min(percentage of achievemnt)} <1

then

"Not Consider for Incentive"

else

"Consider for Incentive"

end

Note: If you are using any dimension filters add them to context

Hope this helps kindly mark this answer as complete or helpful so that it will be helpful,

If not kindly attach the workbook so that it will be easy to help

BR,

NB

• ###### 2. Re: Case or IF statement ???

Hi Amyl,

Can you provide a sample workbook for us to look at?

In short, it looks like a LOD issue. Try to use

IF

{Fixed [State Name]: MIN(Percentage of Achievement) < 1 } Then "Not Consider for Incentive" Else "Consider for Incentive"

End

• ###### 3. Re: Case or IF statement ???

Hi

The both logic didn't workout. can you please check attached file.

Please save the Extract work book in 10.5 version.

Thank you

• ###### 4. Re: Case or IF statement ???

HI Amyl,

*

Write a calculation like below and compute using as per the selected screenshot (state name should be on top followed by product dosage) hope this helps kindly mark this answer as correct or helpful so that it will help others

BR,

NB

1 of 1 people found this helpful
• ###### 5. Re: Case or IF statement ???

Hi Amyl,

Please see attached and below.  I just dragged your calculation to Filter and set it to Consider for Incentive.