14 Replies Latest reply: Jan 25, 2018 12:13 AM by pranav gohil RSS

    can we change sorting rule based on expression?

    pranav gohil

      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:

      sortttttttttttt.PNG

      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..