topic can we change sorting rule based on expression? in App Development

can we change sorting rule based on expression?

Anonymous — Tue, 02 Jan 2018 11:08:02 GMT

hello community,

i have this doubt in my app

i created a bar chart in which i used below expression as measure:

if(Sum(Persons)>10000000, Num(Sum(Persons)/10000000, '###.##Cr'),

Num(Sum(Persons)/100000, '###.##Lacs'))

this expression checks the value and if its greater than 1cr is appends cr after the value else it appends lacs.

after using this i'm getting following output:

so the problem here is it shows 35.86lacs value bar larger than 4.39cr so is there any way i can impose some rule where it will treat lacs value smaller than crore value..

please help..

Re: can we change sorting rule based on expression?

mdmukramali — Tue, 02 Jan 2018 12:17:19 GMT

Hi Pranav,

I have followed marcowedel post to achieve it.

kindly find the attached sample app.

'K','Mil','Bil','Tril') are available in that application.

I think you can change to Lac & Cr

Re: can we change sorting rule based on expression?

Anonymous — Tue, 02 Jan 2018 12:28:48 GMT

sir can you send me the link of that exact discussion where i can find the solution of the matter..

thanks

Re: can we change sorting rule based on expression?

pradosh_thakur — Tue, 02 Jan 2018 12:34:51 GMT

May be this

if(Sum(Persons)>10000000,alt( text(Num(Sum(Persons)/10000000, '###.##Cr')) ,

Num(Sum(Persons)/10000000, '###.##')

),

alt(text(Num(Sum(Persons)/100000, '###.##Lacs') ),

Num(Sum(Persons)/10000000, '###.##')

)

use this expression and may be if required use measure expression in the number formatting instead of auto.

Re: can we change sorting rule based on expression?

mdmukramali — Tue, 02 Jan 2018 12:40:56 GMT

Hi,

Number formatting - millions to billions

check Marco Wedel @marcowedel‌ Reply in that post.

Thanks,

Mukram

Re: can we change sorting rule based on expression?

Anonymous — Tue, 02 Jan 2018 12:45:32 GMT

this way it shows value as 0.36 (i.e) in crores only and it doesnt even append cr at the end

Re: can we change sorting rule based on expression?

pradosh_thakur — Tue, 02 Jan 2018 12:48:19 GMT

hi Pranav

that's why asked you to use measure expression in the formatting.

Re: can we change sorting rule based on expression?

Anonymous — Tue, 02 Jan 2018 12:58:58 GMT

see this its not happening

Re: can we change sorting rule based on expression?

pradosh_thakur — Tue, 02 Jan 2018 13:01:21 GMT

what about this

if(Sum(Persons)>10000000,dual( text(Num(Sum(Persons)/10000000, '###.##Cr')) ,

Num(Sum(Persons)/10000000, '###.##')

),

dual(text(Num(Sum(Persons)/100000, '###.##Lacs') ),

Num(Sum(Persons)/10000000, '###.##')

)

Re: can we change sorting rule based on expression?

pradosh_thakur — Tue, 02 Jan 2018 13:11:59 GMT

I have tried with dual and its working in my app.

Re: can we change sorting rule based on expression?

MarcoWedel — Tue, 02 Jan 2018 22:35:19 GMT

Hi,

maybe one solution could be:

using this expression:

If(Sum(Persons)>10000000,
   Dual(Money(Sum(Persons)/10000000, '###.##Cr',',','.'),Sum(Persons)),
   Dual(Money(Sum(Persons)/100000, '###.##Lacs',',','.'),Sum(Persons))
   )

hope this helps

regards

Marco

Re: can we change sorting rule based on expression?

MarcoWedel — Tue, 02 Jan 2018 22:47:46 GMT

or sorted by measure expression value:

hope this helps

regards

Marco

Re: can we change sorting rule based on expression?

Anonymous — Wed, 24 Jan 2018 05:18:34 GMT

hello sir, marcowedel‌

I came up with one problem with this expression,

If(Sum([Sales Amount])>10000000,

Dual(Money(Sum([Sales Amount])/10000000, '###.##Cr','.'),Sum([Sales Amount])),

If(Sum([Sales Amount])<100000000 and Sum([Sales Amount])>100000,

Dual(Money(Sum([Sales Amount])/100000, '###.##Lacs','.'),Sum([Sales Amount])),

If(Sum([Sales Amount])<100000 and Sum([Sales Amount])>0,

Dual(Money(Sum([Sales Amount])/1000, '###.##K','.'),Sum([Sales Amount]))

,If(Sum([Sales Amount])=0,0.00)

)

in this, it shows value in lacs crore and thousands but what if the value is negative ?? it fails to display those values in the format defined by expression, please help me with this sir.

Example:

Re: can we change sorting rule based on expression?

MarcoWedel — Wed, 24 Jan 2018 22:03:22 GMT

Hi,

you could check e.g. for fabs(Sum(Persons))>100000

Re: can we change sorting rule based on expression?

Anonymous — Thu, 25 Jan 2018 05:13:39 GMT

Yes this works but what if I want to show value in negative if it is negative,

like if my table has values like

example: some positive and some negative values

FY Year Name	cr& lac Final correct
2010-11	0.00
2011-12	-12.71Cr (negative)
2012-13	51.03Cr
2013-14	62.95Cr
2014-15	64.15Cr
2015-16	114.84Cr
2016-17	-76.88Cr (negative)
2017-18	50.69Cr
-	24.12K

regards

Pranav