If you only want a value to display on Wednesdays you may consider using the WEEKDAY formula in conjunction with the an IF statement and the above formula. Roughly I would envision the formula to be: IF NOT the third day of the week then 0 ELSE WEEKVALUE(target line item)
thanks for quick response...it always seems like a simple question but I understand wanting more info 😉
Source Module: Dimension by unique key...composite of SKU, Inventory Status, site, etc. I've add a row that looks up the SKU (list). Time is week.
Target Module: Dimension by SKU (list); time is daily.
Need to bring row "cases" from source to target based on SKU. By adding the "sum by" the weekvalue() wont work. Ideally the value will only show up on target on a Wednesday...but I can always "lag" and "if" to get that.
I think I get it. First, I would not add a SKU line item in the source with Time as SKU will not be changing over time, so it is wasting space. So, in the source, say your code or unique list is 100_200_300_400 where one of those is SKU. Dimensionalize this by time, at the week level which is what i think you have.
Then, create a module by SKU and time, still at the week level and this is where you do the sum (data[sum:target module.SKU]). Now, for the target, you can create a module dimensionalized by SKU at the day level, and you can do a lookup using a SYS Time Filter module dimensionalized by Day with a line item showing the week (SKU.Data[lookup:SYS Time Filter Day.Current Week]) where current week is the line item in the SYS Time module.
Hopefully that makes since, if not I can put some pictures together to help here.