Skip to main content

Issues summing formula

  • March 2, 2021
  • 1 reply
  • 6 views

David U102

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")

Comments

Clara H
  • Lucidite
  • March 10, 2021

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!