Help With Pick match Condition

[naveen341]

HI team

I Am trying to convert number to MIllion/Billions,

I have a Variable vScaleTotalARBal which return M or B or K

i am using pick match like vDivParam=Pick(alt(match($1,'B','M','K',''),0),1000000000,1000000,1000,1)

now if i use $(vDivParam(vScaleTotalARBal)) ir is returning null .

Thanks in Advance

@sunny_talwar 

[sunny_talwar]

Are you storing vDivParam with an equal sign? If you are, then I suggest getting rid of the sign

Pick(alt(match($1,'B','M','K',''),0),1000000000,1000000,1000,1)

 

[naveen341]

Hi Sunny It is not working i am not sure what i am doing wrong

[sunny_talwar · Accepted solution]

Attaching the file I tested on