Skip to main content
David U102
March 2, 2021

Issues summing formula

  • March 2, 2021
  • 1 reply
  • 15 views

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!