Weekvalue formula

Highlighted
Contributor

Weekvalue formula

Hello,

 

I'm trying to pull weekly data into a module that is based on months. I've tried to use the WEEKVALUE formula, it returns 0. My source data has a week value assigned to it. 

 

Thanks 

 

Hina 

5 REPLIES 5
Certified Master Anaplanner

Re: Weekvalue formula

HI @hina1994 ,

 

Why can't we directly refer the line item of Weekly module in Monthly module as Month is one level above in the time hierarchy so system will automatically sums up.

Message 2 of 6
Contributor

Re: Weekvalue formula

I've tried that, it returns 0. 

Message 3 of 6
Certified Master Anaplanner

Re: Weekvalue formula

Can you please make sure that the summary of that line item is Sum (Source Module Weekly)?

Message 4 of 6
Contributor

Re: Weekvalue formula

Hi, 

 

That did the trick - I had the summary as sum, time summary as 0. Changed that to sum it fixed the issue. 

 

Thank you. 

Message 5 of 6
Super Contributor

Re: Weekvalue formula

Hi Hina

 

I think you should mark Kavins post as solution

Message 6 of 6