text object complex logic

[#1]

I need the followig representaion in Text object dynamically if user selects the number the result should be i 3.1bn, 4.2m .......

*the number 3,055,123,456 should be displayed as ("3.1Bn")

*the number 4,160,023 should be displayed as ("4.2M")

*The number 45,801 should be displayed as ("46k")

do respond me

[tresesco]

=If(number/1000000000>1, Round(number/1000000000,0.1)&'Bn',

  If(number/1000000>1, Round(number/1000000,0.1)&'M',

  If(number/1000>1, Round(number/1000,0.1)&'K', number)))

PFA

[sujeetsingh]

You can use nested if statement as

Let the selecting field be Field1 and there is another Field2

=if(GetFieldSelections(Field1)='',then )