How do I sum a selection of weeks using a look up

Contributor

How do I sum a selection of weeks using a look up

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

Message 1 of 3
2 REPLIES 2
Highlighted
Super Contributor

Re: How do I sum a selection of weeks using a look up

Hi,

 

You don't need to do anything special, as shown below.

 

Monthly data.Value = Weekly data.Value

 

Screen Shot 2019-05-10 at 4.23.36 PM.png

 

Thanks,

Message 2 of 3
Contributor

Re: How do I sum a selection of weeks using a look up

Thanks, it did the trick.
Message 3 of 3