Add conditional formatting

hi,

in the activity of level2 sprint 3 model building, I am supposed to use conditional formatting in Ending Inventory line item based on Safety Stock Target values for different Product SKU (display Ending Inventory as red when the value is less than the Safety Stock Target value) but I am not able to set minimum and maximum values as different SKU have Different Safety Stock Target values.

Screenshot (40)_LI.jpg

Accepted answers

anirudh

Hi Swapnil,

Yes that's correct
Add another line item with the formula:
IF Ending Inventory < Safety Stock Target then 1 ELSE 0
Then use this line item for conditionally formatting the Ending Inventory line item

The advantage with the static value of 1 is that now you can easily set the minimum and maximum value to 0 and 1 respectively and not worry about the actual difference in the inventory and safety stock

Regards,
Anirudh

Regards,
Anirudh

All comments

Misbah

@swapnil_J

I might be wrong but as far as I know Ending Inventory doesn't need to be formatted. Only Safety Stock Exception Count was supposed to be formatted. Can you please show us what is the requirement?

swapnil_J

Hi Misbah,

Screenshot (42)_LI.jpg

I think I should add another line item which compares the values in Ending Inventory and Safety Stock Target line items and use the value for conditional formatting.

anirudh

TulasiNayak

Hi!

I had a followup question,

There is already a line item called- Safety Stock Exception Count = IF Ending Inventory < Safety Stock Target then 1 ELSE 0

But the activity has asked to delete this line item

Should I keep this line item and format it? or is there another was to format the Ending inventory Line item?

Thanks!

Tulsi

swapnil_J

Hi!

You should keep Safety Stock Exception Count line item. It will give you total number of exception occurs during the period.

JarrodRywolt

In the DEM03 Demand Forecast module, it was instructed to set up a Forecast cf line item for conditional formatting.

The Safety Stock Exception Count line item in the INV01 Inventory Ordering can serve this purpose, but the cf naming practice does not seem to be utilized here if we depend on Safety Stock Exception Count as the name of the format condition, perhaps Ending Inventory cf would be more consistent with suggested naming conditions for purpose of setting up UX.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385