prabhu 
Reactions
-
Re: Level 1 Model Building - Importing Data
Hi @Star, You are doing really well. 1 thing you should change. in the Sys06 Product Details Module, you should write a formula for Code and Product Family as CODE(ITEM('P2 Products')) and PARENT(ITE…1 -
Re: IF function without ELSE condition
Hi @jairamkamath, This is possible using Previous function. Previous Function Takes the Previous value of the same line item. But your module should have Time as a dimension.1 -
Re: CODE, PARENT AND 'GRANDPARENT' FUNCTION
Hi @Star, There is no Grand Parent Function. You can use in 2 ways. 1. PARENT(PARENT(ITEM('G3 Location'))) 2. PARENT(Country) Country -> Line Item Both Result the Same Output. Thanks, Sorna Raja P…1 -
Re: Level 1 Model Building
Hi @krw6, Error is in your line item name. Double click your current line item or the line item which you are trying to write the formula and select the appropriate line item from REV02 Volume Inputs…1 -
Re: line item with no time dimension
Hi @Ana22, Yes it is Possible. Step 1: You have a Time Dimension Module and amount line item. Create another Line item(last non blank) of Text format and write the formula as mentioned below. Step 2:…1
