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