Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have expression
Num((Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE)/1000000), '#,##0.00;(#,##0.00)')
But instead of two decimal, I want option to select how many decimal end user wants. So I applied as below in red
Num
((Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE
)/1000000), '$(=vDivision)') Where vDivision is variable and value for this is
#,##0.00;(#,##0.00)
But it does not work
Is there any way to apply variable
Thanks in advance
Hi @Anonymous
I just tested and it works fine:
Variable Value (vFormat sample variable):
#,##0.0000;(#,##0.0000)
Expression:
=Num( 12345670000, '$(vFormat)')
Kind Regards,
Hi Satish,
if the variable is just set like that you don't need to dollar expand it, just use.
you only would need to dollar expand if the variable contained an expression and you wanted to use the result from it.
((Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE
)/1000000), vDivision)
hope that helps
Joe
Hi Joe
I used as below
((
Sum({$<QUARTER = {99}>} jATTRIBUTE_VALUE
)/1000000), 'vDivision') where vDivision is
'#,##0.00;(#,##0.00)' is variable
I am not getting required result but all zeroes. Am I making any mistake here?
Thanks for your time and follow up.
No quotes needed:
num(<expression>, vDivision)
Thanks Michael & Joe for your valuable suggestion
Yea as Michael says no quotes, I missed taking the second one away in my post sorry, have edited now
Hi @Anonymous
I just tested and it works fine:
Variable Value (vFormat sample variable):
#,##0.0000;(#,##0.0000)
Expression:
=Num( 12345670000, '$(vFormat)')
Kind Regards,