7 Replies Latest reply: Dec 4, 2016 5:30 AM by Yeo Poh sai

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

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

my QVF

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

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% ?

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% ?

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% ?

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% ?

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% ?

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