L1 MB Lesson 6.6.5 - Add Formulas to Time Settings by Year

Candy
Contributor

L1 MB Lesson 6.6.5 - Add Formulas to Time Settings by Year

Hello,

Formulas were added to line items as per below instructions.

Candy_0-1615362618936.png

But I am getting a different results to the example module. In my module, check marks are missing for line item 'Forecast Period' under FY20 and FY21 columns.

 

The formulas are the same so I can't work out why the check marks are missing on my module.

 

My Module

Candy_1-1615362807445.png

Candy_3-1615362845012.png

 

Example Module

Candy_4-1615362878058.png

Candy_6-1615362933297.png

 

Greatly appreciate your help.

Thank you!

Candy

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
AntonMineev
Regular Contributor

Re: L1 MB Lesson 6.6.5 - Add Formulas to Time Settings by Year

Hi @Candy!

When you change summary methods in source Line Items (See your previous questions: see your previous questions) you can see that the formula in this question will work correctly. At the moment, she simply has no place to get the value for the year (it is not counted in the source module).

View solution in original post

JaredDolich
Moderator

Re: L1 MB Lesson 6.6.5 - Add Formulas to Time Settings by Year

@Candy as @AntonMineev suggested, once you change the summary methods of the Line Items in SYS00 to "ANY" this will resolve itself.


Jared Dolich

View solution in original post

3 REPLIES 3
AntonMineev
Regular Contributor

Re: L1 MB Lesson 6.6.5 - Add Formulas to Time Settings by Year

Hi @Candy!

When you change summary methods in source Line Items (See your previous questions: see your previous questions) you can see that the formula in this question will work correctly. At the moment, she simply has no place to get the value for the year (it is not counted in the source module).

View solution in original post

JaredDolich
Moderator

Re: L1 MB Lesson 6.6.5 - Add Formulas to Time Settings by Year

@Candy as @AntonMineev suggested, once you change the summary methods of the Line Items in SYS00 to "ANY" this will resolve itself.


Jared Dolich

View solution in original post

Candy
Contributor

JarrRe: L1 MB Lesson 6.6.5 - Add Formulas to Time Settings by Year

Thank you Anton & Jared! 😃