Weekvalue formula



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. 





Best Answers

  • 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
    Answer ✓

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

  • 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.