Filter

[Sameer9585]

Hi, I need to create a filter in such a way that It should convert the complete data of sales from thousands to million means for example 10 k to 0.1 M it should convert

[arpitkharkia · Accepted solution]

Hi,

1. Create an inline table for the list box.

2. Write your expression as

if(GetFieldSelections(YourList)='Thousand',"Thousand Format Expresion")

I hope its clear! 🙂

[Sameer9585]

Can you help me in clear? I'm not getting it.

[arpitkharkia]

PFA

[Sameer9585]

I am not clear at the expression step not at the Inline list

[arpitkharkia]

=if(GetFieldSelections(List)='Thousand',
Num(YourExpressionHere/1000,'#######K'),
if(GetFieldSelections(List)='Million',
NUm(YourExpressionHere/1000000,'########M')))

which part?

[Sameer9585]

Where I should type this expression? That's the main doubt

[arpitkharkia]

Wherever you want to show the values. In  chart/text box etc.