
Creator
2019-09-20
11:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Help With Pick match Condition
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
1,235 Views
1 Solution
Accepted Solutions

MVP
2019-09-20
02:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Attaching the file I tested on
1,198 Views
3 Replies

MVP
2019-09-20
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
1,227 Views

Creator
2019-09-20
02:13 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny It is not working i am not sure what i am doing wrong
1,203 Views

MVP
2019-09-20
02:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Attaching the file I tested on
1,199 Views
