Skip to main content

Here is the formula I am attempting to use to sum values filtered by properties. It is only summing if there are more than two values returned. Why would Sum not work on single values?


=SUM(Filter(Filter(CONTENTSWEEK(DATE(YEAR(DATEADD("days"7NOW))@'Ship By Month'@'Ship By Day'))= WEEK(DATEADD("days"7NOW)))@'Rush Percent'="STD")."Job List")

Hi David


Thanks for posting on the community! I don’t completely understand the issue you are experiencing-- would you mind providing me with ascreenshot and detailed description of the issue so I can take a closer look?


Thanks in advance for your help and patience!


 


Reply