Sigma Community

Total Sum for Previous Three Months

Sigma Formulas and Functions

ztrean October 26, 2020, 10:20pm #1

Can someone help me out with a total column formula for the sum of a column that will always only be the last three months?

Ryan October 26, 2020, 10:21pm #2

Hey Zachary!

Try using this formula:

SumIf([Column], DateDiff(“month”, [Date], Now()) <= 3)

system automatically bumped November 11, 2020, 9:49am #3

system automatically bumped December 1, 2020, 3:07am #4

system automatically bumped December 20, 2020, 5:21am #5

system automatically bumped January 9, 2021, 9:09am #6

system automatically bumped January 29, 2021, 5:37pm #7

system automatically bumped February 20, 2021, 3:24am #8

system automatically bumped March 13, 2021, 1:25pm #9

system automatically bumped April 4, 2021, 3:22am #10

system automatically bumped April 25, 2021, 5:18pm #11

system automatically bumped May 17, 2021, 1:12pm #12

system automatically bumped June 8, 2021, 7:08pm #13

system automatically bumped July 1, 2021, 3:52pm #14

system automatically bumped July 24, 2021, 8:17am #15

system automatically bumped August 15, 2021, 11:32pm #16

system automatically bumped September 8, 2021, 11:36am #17

system automatically bumped October 1, 2021, 9:53pm #18

system automatically bumped October 26, 2021, 12:35am #19

system automatically bumped November 19, 2021, 3:43am #20