Need help in creating correct Formula to get Employee expenses by Roles and Department

I assumed, I have created a formula using LOOKUP to get correct value in Employee expenses module however the outcome is incorrect when I am answering the questions related to it.

Hence I believe my formula is incorrect.

Not sure if someone having expertise on this can guide me to build a correct module here.

Thank You

Janmejaya

Accepted answers

All comments

Misbah

@JPani

To answer your questions correctly you need to make sure that the name of the module as well as name of the line item is exactly matching with that of Training. Spacing, naming convention plays important role, so go back to the training content and make sure that everything is as per the training.

Hope that helps

Misbah

Miz Logix

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…