Sprint 3 Create Product Replenishment Page

ankitaga2000
Frequent Contributor

Sprint 3 Create Product Replenishment Page

Can anyone help me with the conditional formatting for ending inventory.

ankitaga2000_0-1616386299779.pngankitaga2000_1-1616386331894.png

I am not getting what to write for minimum and max value so as to get the red flag

 

Regards,

Ankita

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: Sprint 3 Create Product Replenishment Page

@ankitaga2000 

 

Formula can never be written on Dashboards or Pages. You will have to go back to the INV01 module, create a line item and write a formula there in the module. Once you are done then come back to the NEW UX Page and Select that line item to apply the formatting in the NUX.

View solution in original post

3 REPLIES 3
Misbah
Moderator

Re: Sprint 3 Create Product Replenishment Page

@ankitaga2000 

 

You will have to write the formula in CF Line item which says

If Ending Inventory < Safety Stock Target then 1 Else 0

Treat 1 as Red

Mid Point is Optional - You can ignore it

0 as Green

 

Hope that helps

Misbah

 

ankitaga2000
Frequent Contributor

Re: Sprint 3 Create Product Replenishment Page

I don’t get any option to write the formula of conditional formatting in ux page . It just says directly to select the line item . 
@Misbah 

Misbah
Moderator

Re: Sprint 3 Create Product Replenishment Page

@ankitaga2000 

 

Formula can never be written on Dashboards or Pages. You will have to go back to the INV01 module, create a line item and write a formula there in the module. Once you are done then come back to the NEW UX Page and Select that line item to apply the formatting in the NUX.

View solution in original post