prabhu

Overview

Overview

Roles	MemberPartner
Badges	23

About Me

About Me

Not much happening here, yet.

Analytics

184

Posts

11

Visits

674

Points

Nov 5, 2019

Join Date

Apr 9, 2025

Last Active

Reactions

• Like 142

  142

• Activity
• Posts2
• Comments182

• Re: Level 1 Model Building - Importing Data

  prabhu

  March 2020
  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

  prabhu

  March 2020
  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

  prabhu

  March 2020
  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

  prabhu

  March 2020
  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

  prabhu

  March 2020
  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

Next