Make a Line item Sign Change

Hi,

I would like to know if it is possible to make a line item that I'm drawing data into from a flat file to make the numbers coming in negative. I have a Flat File where the numbers are negative on the Flat File, but need them to be positive in Anaplan (Vice Versa). How would I go about this without completely changing my Flat File.

Thank you

Accepted answers

Kanishq17

Hi @neg177 , you can create a second line item and multiply the imported value by -1, and use that calculated line item

All comments

AWhitworth

Hi,

I don't believe you can do this using the import action but I would normally set up a second line item in the same module which references your imported data line item and changes the signage that way.

JaredDolich

Agree with @AWhitworth

There is an alternative to adding another line item though. If you have the time, I HIGHLY recommend Simon Tucker's video on best practices for signage. 5:30 minutes. Totally worth it. Simon's videos are some of the best.

https://community.anaplan.com/t5/Best-Practices/Modeling-Best-Practices-Video-Series-2-Signage-Convention/ta-p/93236

rob_marshall

@JaredDolich

I think you might need some sleep, that was David, not Simon.

JaredDolich

@rob_marshall HAHAHAHA! I was sure it was Simon. @DavidSmith wherever you are, my apologies!!

Kanishq17

Hi @neg177 , you can create a second line item and multiply the imported value by -1, and use that calculated line item

neg177

That works, Thank you

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…