Can anyone help me with the conditional formatting for ending inventory.
I am not getting what to write for minimum and max value so as to get the red flag
Regards,
Ankita
@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
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
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.
Please take note of the following changes in our latest 2608 release: Multi-dimensional calculations now require valid rules. As of 2608, the multi-dimensional calculation process no longer runs when invalid rules are present - for example, a rule referencing an invalid member (one that no longer exists in the dimension).…
As part of the FCR Release 2608 update, enhancements were introduced to improve data import performance and ensure correct column data typing for ADO Imports to FCR. Specifically: Schema Correction: Staging tables now properly instantiate numeric columns as float rather than defaulting to string. Performance Optimization…
