This content has been marked as final.
Show 3 replies

Re: Why need to compute by if XXX >1,1 then compute the sales / target ?
Settu Periyasamy Jun 27, 2016 10:27 PM (in response to PAUL YEO)Regarding the 1st expression, if we don't want to see more than 100% we can apply the if statement.
It is forcefully / manually make it as 100% when the Sales vs Target >100.
like
if(Sales vs Target > 100% then Make it as 100% (some of them don't want to see more than 100%),
else the normal calculation.

Re: Why need to compute by if XXX >1,1 then compute the sales / target ?
PAUL YEO Jun 27, 2016 10:41 PM (in response to Settu Periyasamy)Hi Sir
Thank you very much for your clarify.
So can I said if I compute table to display target achievement . I should not apply if .
For plot % chart then I need to use if to limit 100%. Right ?
Paul
Sent from my iPhone

Re: Why need to compute by if XXX >1,1 then compute the sales / target ?
Settu Periyasamy Jun 27, 2016 10:45 PM (in response to PAUL YEO)Yes, if we need the original % value, then we don't want to apply 'if' statement.

