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

dylancolliflower
Occasional Contributor

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
JussiLi
Frequent Contributor

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

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

View solution in original post

1 REPLY 1
JussiLi
Frequent Contributor

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

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

View solution in original post