Ability to export values as formatted for .CSV

As a user, I need to be able to export data in the format I have set instead of a standardised format when exporting as .CSV.

For example, I want to be able to export

Large numbers - The option to export "1,000,000,000,000" rather than "1.0E12"
Small numbers - The option to export "0.00001" rather than "1.0E-5"

My data feeds other systems that do not accept scientific notation and I currently have to create external workarounds for this

Comments

Miran

Status changed to: Delivered

Gwen.pryor

Status changed to: Delivered

dafinkapancheva

Model builders and workspace administrators can now select an option to export formatted numbers for unformatted file types: text, CSV, unformatted XLS, and XML. This makes it easier to use the data in other applications. The exported numbers match the number of decimal places set up for the line item, and use "." as the decimal indicator. No thousand separator is used, and custom units and currency symbols are not exported.

Quick Links

New ideas

Anaplan Color Pallet
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: The Anaplan Color pallet should be consistent across all forms. Text Pallet is different Action Icon Default Colors, and different…
Workflow: Continue Workflow after Decision Task Rejection
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Currently a workflow ends if a decision task is rejected and it is not possible to add workflow steps after the rejection. I want to…
Allow non-WSAs to view source module name in UX.
When a user clicks the ellipsis in a grid card they should be able to see the name of the source module. This empowers end users with the ability to connect to the source data they see in the UX to the module in the backend. It also enables end users to pull the data into Google Sheets or Excel.