You could create a variable, let say vNumFormat and assign your format to that variable. Then use it the num expression:
=num(Field, $(vNumFormat))
If you need to change your format, you won't need to change each expression, but instead just change the value in the variable and it will apply wherever its contained.
About the zero, I think it has to do with the total of decimal positions that you want.
If you have the expression as Sum(Sales) in straight table then go to properties -> number tab-> here you can set the various format like money, number , timestamp , date etc for that expression
go to properties -> number tab-> here you can set the various format like money, number , timestamp , date etc for that expression
copy number format & paste with following formula
Num( sum(Sales) , ' Copy here number format')
Hope this is short way
vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Maintain your Number format sheet and load through loop in your App and apply whatever you want the format on your fields.
OR
Go to Properties > Tab "Number" > Select your Expression/Field Name > Number Format Settings > Select your required Format > Copy Format Pattern > Apply > OK.
Now you can apply copied format pattern with Num function. Example: =Num(Sum(Sales), '#,##0.00')
You can copy a whole expression including its format. Right click it on the expression on the Expressions tab of your source chart and copy it and then on your target chart Expressions tab go to the bottom of all your expressions, right click on the white space just below your expressions and paste it in.
