topic Re: How to make -125.8% display as +100% ? in App Development

How to make -125.8% display as +100% ?

paulyeo11 — Sat, 03 Dec 2016 12:58:48 GMT

Hi All

I have a expression.

(

sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(YearStart(Today())))<=$(=num(Today()))"}>} Amount*-1/1000)

sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(AddYears(YearStart(Today()), -1)))<=$(=num(AddYears(Today(), -1)))"}>} Amount*-1/1000)

)

sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(AddYears(YearStart(Today()), -1)))<=$(=num(AddYears(Today(), -1)))"}>} Amount*-1/1000)

Now mu issue is when 2015 net profit amount -ve and 2016 net profit amount +ve , it display -ve % , which is wrong , i like to make it display 100%.

Hope some one can advise me.

Paul

Re: How to make -125.8% display as +100% ?

paulyeo11 — Sat, 03 Dec 2016 12:59:47 GMT

my QVF

Re: How to make -125.8% display as +100% ?

sunny_talwar — Sat, 03 Dec 2016 18:02:18 GMT

Why would you see a 100%? Is this in general that any time you have a negative %age, you would want to see 100%?

Re: How to make -125.8% display as +100% ?

paulyeo11 — Sun, 04 Dec 2016 09:17:08 GMT

Hi Sunny

I miss your reply.

I am think if it is able see +ve % I am

Fine.

As it is not easy to compute to show the actual % growth from -ve to + ve.

Paul

Get Outlook for iOS<https://aka.ms/o0ukef>

Re: How to make -125.8% display as +100% ?

vinieme12 — Sun, 04 Dec 2016 09:57:55 GMT

i think you have reused an expression to show amount in $000's that's why dividing by 1000!

but you don't need that for the percentage calculation.

Also if the increase / decrease percentage is -125% or +125% you should show it as it is instead of ceiling to 100%

(

sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(YearStart(Today())))<=$(=num(Today()))"}>} Amount)

sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(AddYears(YearStart(Today()), -1)))<=$(=num(AddYears(Today(), -1)))"}>} Amount)

)

sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(AddYears(YearStart(Today()), -1)))<=$(=num(AddYears(Today(), -1)))"}>} Amount)

Re: How to make -125.8% display as +100% ?

paulyeo11 — Sun, 04 Dec 2016 10:16:45 GMT

Hi Vineeth

Thank you for your sharing.

If you see carefully , the bar chart , shown that profit for 2015 was -ve value , and 2016 was +ve value.

the fact is that logically the % should be +ve , but your expression is still show -ve.

Paul

Re: How to make -125.8% display as +100% ?

vinieme12 — Sun, 04 Dec 2016 10:21:20 GMT

Hi Paul,

Recheck your expression for profit, you are multiplying it with -1.

What is the purpose of multiplying profit with -1?

Re: How to make -125.8% display as +100% ?

paulyeo11 — Sun, 04 Dec 2016 10:30:10 GMT

Hi Vineeth

You are right , the -ve sign should not be there , i think i accidently enter in , which is wrong. after i remove the -ve sign.

Now after remove the -ve sign. but for TDSID , how to make it display +ve % ?

Paul