Weekvalue formula

[hina1994]

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 

[kavinkumar · Accepted solution]

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.

[hina1994]

I've tried that, it returns 0. 

[kavinkumar · Accepted solution]

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

[hina1994 · Accepted solution]

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. 

[harish_bk]

Hi Hina

I think you should mark Kavins post as solution 😉