Hi All

Amankrydv
Amankrydv
edited June 2023 in Integrations and extensibility

I am having a problem while importing my data. I have data which has negative sign after the values. Anaplan is not able to recognize it and the values are imported as positive. How can we fix this??

Best Answer

  • CommunityMember121571
    CommunityMember121571
    Answer ✓

    I would try to use a stage module/line item

    1. import as text
    2. recognize numbers by value funtcion
    3. catch sign by right function, if "-" then (-1) else 1
    4. multiply steps 2*3

    Best,

    Konstantin

Answers

  • Amankrydv
    Amankrydv

    Thank You Konstantin, the issue is solved. The only problem I got when I used VALUE() function, it returned NaN for text have negative sign at the end.

  • CommunityMember121571
    CommunityMember121571

    I see.

    Then

    • either upload them as numbers and use text only for sign define
    • either concatinate text to use in value function

    Best,

    Konstantin

Categories