How to import Negative Values from txt files

Options
Shawnm
Shawnm
in Integrations and extensibility

Hi All,

I am importing data from tab separated txt files and I noticed wherever the values are negative, its populating as positive numbers in Anaplan.

image.png

As shown in above example the negative values are denoted by a negative sign after the number in the txt file. Is this format supported by Anaplan?

Thanks in advance

Tagged:

Best Answer

  • anand.shekhawat
    anand.shekhawat
    Answer ✓
    Options

    Hi @Shawnm

    Anaplan does not recognize the format that you are trying to load. It only recognizes the negative numbers when a negative sign is prefixed with the number or the number is placed in brackets. Eg -100, (100) etc

    I hope it helps

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

  • Venki9902
    Venki9902
    edited May 2023
    Options

    Hi @Shawnm ,

    Anaplan considers 10000.00- as positive only.
    It only recognizes the negative numbers when a negative sign is prefixed with the number or placed in brackets.
    Example:File I have loaded

    image.png
    image.png

    Kindly correct your file and load it.

    Hope this helps :).

    Regards,
    Venkatesh

Categories