Trouble Finding a way to Convert Values from Half Year to Weekly Values

I am working through Level 2 Sprint 3 training and I am having trouble with creating a formula to convert data stored on a half year time scale to a weekly time scale. I would assume weekvalue('SOURCE Line Item') would be the correct function but I am not getting any values. I have changed the time summary method on the source data and still no values flow through. 

Tagged:

Best Answer

  • JussiLi
    Answer ✓

    Hi @dylancolliflower,

     

    Try to use HALFYEARVALUE function. That should work if you need to fetch data from half year time scale module to weekly time scale module.

     

    Best regards, 

    JussiLi