Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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! 🙂
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! 🙂
Can you help me in clear? I'm not getting it.
PFA
I am not clear at the expression step not at the Inline list
=if(GetFieldSelections(List)='Thousand',
Num(YourExpressionHere/1000,'#######K'),
if(GetFieldSelections(List)='Million',
NUm(YourExpressionHere/1000000,'########M')))
which part?
Where I should type this expression? That's the main doubt
Wherever you want to show the values. In chart/text box etc.