Difference between revisions of "Exporting Currency Values to Excel from List Views"
From SmartWiki
(Created page with 'The list view export now checks if the Number Format in the custom field being referenced is set to Currency, and then will strip the currency formatting out. This will not work…') |
|||
| Line 1: | Line 1: | ||
The list view export now checks if the Number Format in the custom field being referenced is set to Currency, and then will strip the currency formatting out. | The list view export now checks if the Number Format in the custom field being referenced is set to Currency, and then will strip the currency formatting out. | ||
| − | This will not work for Read Only - System Variable fields. | + | This will not work for [[Custom Field Type: Read Only – System Variables|Read Only - System Variable]] fields. |
| − | This will work if the field is a Store Value - System Variable with a variable such as | + | This will work if the field is a [[Custom Field Type: Store Values – System Variables|Store Value - System Variable]] with a [[variable]] such as |
<nowiki><!--hideifnotfound-->@xml.Hybrid Budget.Revenue.Grant.Rev-Amount.nodevalue@</nowiki> | <nowiki><!--hideifnotfound-->@xml.Hybrid Budget.Revenue.Grant.Rev-Amount.nodevalue@</nowiki> | ||
(and the Number formatting is set to Currency) | (and the Number formatting is set to Currency) | ||
...but not if the currency is defined in the variable, such as | ...but not if the currency is defined in the variable, such as | ||
<nowiki><!--hideifnotfound-->@xml.Hybrid Budget.Expenses.Capital.Currency(Ex-Amount.nodevalue)@</nowiki> | <nowiki><!--hideifnotfound-->@xml.Hybrid Budget.Expenses.Capital.Currency(Ex-Amount.nodevalue)@</nowiki> | ||
Revision as of 13:12, 21 June 2013
The list view export now checks if the Number Format in the custom field being referenced is set to Currency, and then will strip the currency formatting out.
This will not work for Read Only - System Variable fields.
This will work if the field is a Store Value - System Variable with a variable such as
<!--hideifnotfound-->@xml.Hybrid Budget.Revenue.Grant.Rev-Amount.nodevalue@
(and the Number formatting is set to Currency) ...but not if the currency is defined in the variable, such as
<!--hideifnotfound-->@xml.Hybrid Budget.Expenses.Capital.Currency(Ex-Amount.nodevalue)@
