Currently we have a formula that is returning the last week of the month from the look up. How do I get the look up to do a sum of all weeks within the month ?
CURRENTVERSION()'.h_collect previous version[SELECT: ..., LOOKUP: Time filter.'H2 End wk'])
The H2 End week needs to be a sum of the month ...
Go to Solution.
You don't need to do anything special, as shown below.
Monthly data.Value = Weekly data.Value