Make a Line item Sign Change

neg177

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 

Kanishq17

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

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!!

neg177

That works, Thank you