rename the class function value

[brijeshvma]

Hi all I am using a Class function for Price Bucket :

Dual(Replace(Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000),'<= x <', 'To'),

Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000))

So i am Getting a value like

0 to 2500000

25000000 to 5000000

But i want to show figure like

o to 2500K

2500K To 5000K

Kinldly help me achieve this.

i have a attached a image of bar as well'

[sunny_talwar · Accepted solution]

May be this:

Dual(

SubField(Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000),'<= x <', 1)/1000 & 'K To ' &

SubField(Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000),'<= x <', 2)/1000 & 'K',

Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000))

[mightyqlikers]

use

KeepChar(SubField(SearchVertical,':',2),'0123456789')

in the back end and create a field divide by 1000

and use that in front end using class function.

$@M

[brijeshvma]

Thankks Sunny

[swuehl]

Or maybe (since there is not much benefit to use the class function then in your case):

Dual(

Floor(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000)/1000 & 'K To ' &

Ceil( KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000)/1000 & 'K',

Floor(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000)

)