Over %100 format

[asknyldz]

Hi there,

How can i format over %100 to +%100

ie

%150 should be +%100

Regards

[arvind_patil]

Hi Askin,

Please explain more in deep.

Thanks,

Arvind Patil

[zhadrakas]

try this

='+' & num(max(Value), '0%')

regards

[Anil_Babu_Samineni]

What if you use some thing like below

= '+' & Expression

[Frank_Hartmann]

Not sure if i understood you correctly but maybe like that:

if(Value>100,'+%'&100,'%'&Value)

[asknyldz]

Dear All,

Thanks for replies, I didn't success.

I want to explain more.

This is the my Expression. This formula result is showing 1500.0%

I want to show is 100.0%+

If result under 100.0%, it can be show original value, but when result is over 100.0%, i want to show 100.0%+

num(((if(CURTYPE='All in USD',sum({<TYPE={'CY'}>}PREMIUM),sum({<TYPE={'CY'}>}PREMIUM_TL))/if(CURTYPE='All in USD',sum({<TYPE={'PY'}>}PREMIUM),sum({<TYPE={'PY'}>}PREMIUM_TL)))-1),'#,##0.0%')

Regards,

[Frank_Hartmann]

Maybe like this:

if(num(((if(CURTYPE='All in USD',sum({<TYPE={'CY'}>}PREMIUM),sum({<TYPE={'CY'}>}PREMIUM_TL))/if(CURTYPE='All in USD',sum({<TYPE={'PY'}>}PREMIUM),sum({<TYPE={'PY'}>}PREMIUM_TL)))-1),'#,##0.0%')>1,1,num(((if(CURTYPE='All in USD',sum({<TYPE={'CY'}>}PREMIUM),sum({<TYPE={'CY'}>}PREMIUM_TL))/if(CURTYPE='All in USD',sum({<TYPE={'PY'}>}PREMIUM),sum({<TYPE={'PY'}>}PREMIUM_TL)))-1),'#,##0.0%'))

[asknyldz]

Thanks Frank,

I changed as below but now showing +100%+

I see double + icon front and end. Very interesting. I want to see only end

if(num(((if(CURTYPE='All in USD',sum({<TYPE={'CY'}>}PREMIUM),sum({<TYPE={'CY'}>}PREMIUM_TL))/if(CURTYPE='All in USD',sum({<TYPE={'PY'}>}PREMIUM),sum({<TYPE={'PY'}>}PREMIUM_TL)))-1),'#,##0.0%')>1,num(100,'#,##0%'&'+'),num(((if(CURTYPE='All in USD',sum({<TYPE={'CY'}>}PREMIUM),sum({<TYPE={'CY'}>}PREMIUM_TL))/if(CURTYPE='All in USD',sum({<TYPE={'PY'}>}PREMIUM),sum({<TYPE={'PY'}>}PREMIUM_TL)))-1),'#,##0.0%'))

[Frank_Hartmann]

try this:

if(num(((if(CURTYPE='All in USD',sum({<TYPE={'CY'}>}PREMIUM),sum({<TYPE={'CY'}>}PREMIUM_TL))/if(CURTYPE='All in USD',sum({<TYPE={'PY'}>}PREMIUM),sum({<TYPE={'PY'}>}PREMIUM_TL)))-1),'#,##0.0%')>1,right(num(100,'#,##0%'&'+'),5),num(((if(CURTYPE='All in USD',sum({<TYPE={'CY'}>}PREMIUM),sum({<TYPE={'CY'}>}PREMIUM_TL))/if(CURTYPE='All in USD',sum({<TYPE={'PY'}>}PREMIUM),sum({<TYPE={'PY'}>}PREMIUM_TL)))-1),'#,##0.0%'))

[passionate · Accepted solution]

Hi Askin,

Try using this in your expression:

If(Sum(Profit)/Sum(Sales)*100>100,'+100%',NUM(Sum(Profit)/Sum(Sales)*100,'#.#0')&'%')

Here my expression is: Sum(Profit)/Sum(Sales)

Put your expression accordingly.

Regards,

Pankaj