Weekvalue formula

hinamahmood1994
hinamahmood1994
in Modeling

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 

Tagged:

Best Answers

  • kavinkumar
    kavinkumar
    Answer ✓

    HI @hinamahmood1994 ,

     

    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.

  • kavinkumar
    kavinkumar
    Answer ✓

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

  • hinamahmood1994
    hinamahmood1994
    Answer ✓

    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. 

Answers

Categories