Format checker

Format checker

I want Anaplan to check if the FORMAT of my line item correspond the the formula i'm entering BEFORE starting the calculation and if the format doesn't match the expected result, i want Anaplan to hold the calculation until i can change the format to match the formula results.

 

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
7 Comments
Community Manager

Thanks for the idea @annejulie - Moving this to acknowledged so that it can continue to get support!

Status changed to: Needs Community Support
Community Boss

Same idea occured to me (probably after my zillionth rollback from forgetting to change the format type), except I would add that it should be smart enough to know what format my formula is attempting to return, and offer to change it for me.  i.e. if I'm typing something that should be a boolean in a new line item that is a Number format...offer to change it to a boolean for me and then apply the formula.

Certified Master Anaplanner

I think this is a wonderful idea and would be a good start for the concept of "predictive modeling".  This may seem like a relatively minor thing but it can be a source of irritation when you know the formula and simply forget to update the format prior to input.  Thanks for suggesting @annejulie!

Community Boss

Just adding, some of the checking could be easy, but other times, the calculation will have to run to know what the result is, but I agree that simple checks would be great

Occasional Contributor

I think we have a lot customers requesting for this and the impact of rollback adds more impact.

Community Manager
 
Status changed to: Under Investigation
Community Manager
 
Status changed to: On Roadmap