Enter Formula

SatyamArora

Hi,

Curious to know if I enter the formula at the line item directly, would it work (screenshot)?

Im doing LM1, reccommneded method is to double click and write on top or expand the formula bar.

But looks like it is editable at the line item directly as well, but I am not sure if it will work..

Screen_Shot_2020-03-17_at_8_64071.png

Accepted answers

Akhtar.shahbaz

Hi @SatyamArora

Yes it will work perfectly if you enter the correct formula.

Only limitation is that by chance if you enter a wrong formula then again you have to write a formula but if you edit the line items and enter the formula in formula bar then your formula still be there & you can change formula directly.

Thanks

Akhtar

All comments

Akhtar.shahbaz

Hi @SatyamArora

Yes it will work perfectly if you enter the correct formula.

Thanks

Akhtar

JaredDolich

@SatyamArora

Great question.

@Akhtar.shahbaz is right.

In fact, some people prefer to edit formulas in grid view because they can see the results right away.

SatyamArora

Thanks for your help @Akhtar.shahbaz , @JaredDolich .. Followup question, does syntax matter - space, uppercase or lowercase

Akhtar.shahbaz

Hi @SatyamArora

You can write syntax either in upper case or lower case doesn’t matter but of course space matter for syntax. for example

you can write “isnotblank” or ISNOTBLANK bith are acceptable but if you give space in between like “IS NOTBLANK” then it will throw error.

Hope this helps!

Thanks

Akhtar

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…