Export with same formatting
Hi,
Is it possible to export with the same formatting as the module / dashboard ?
e.g. I have zeros showing as blanks or dashes, but when exported, it's coming up as 0 in the excel.
Thanks in advance,
Answers
-
No, the underlying data will always be exported. You could, but you shouldn't, have a text representation of that data to achieve the same effect. But don't do this, Text is bad for the model and I should never have mentioned it.
I'd apply the same formatting in Excel afterwards.
Using the Excel add-in may help if you're looking to export to Excel in a specific way...
Excel Add-in Series 4 - Anaplan Technical Documentation0 -
You can export module as "text" as an option, you would get the desired result.
Regards,
Rahul
0 -
Doesn't quite work - exporting as text creates a notepad?
0 -
0
-
Is that only possible in the Old UX? i've got this in the NUX and it doens't provide the option?0
-
Yes, that would have been old UX/blueprint view. See below for option in NUX.
0 -
Thanks - but that doesn't work. I lose the formatting when exporting if using the methodology you've just shown.
0 -
Very odd, as it works for me. Could be something in your Excel configuration.0
