I am struggling with a formula to have a columns c...
# suiteanalyticst
Thomas
03/03/2020, 7:03 PMI am struggling with a formula to have a columns count for yesterday, MTD, YTD any help would be great
g
Gregory Jones
03/03/2020, 7:14 PMGregory Jones
03/03/2020, 7:14 PMCould be a good starting point
t
Thomas
03/03/2020, 7:22 PMthank you
g
Gregory Jones
03/03/2020, 7:32 PMHope it helps!
t
Thomas
03/03/2020, 8:03 PMIt got me MTD to date and YTD now just need yesterday thanks
g
Gregory Jones
03/03/2020, 8:17 PMTRUNC({today})-1
t
Thomas
03/03/2020, 8:23 PMCASE WHEN {trandate} IS to_date(TRUNC({today}, -1) THEN ELSE 0 END where am off?
g
Gregory Jones
03/03/2020, 8:27 PMIs it erroring, or just not returning the right results? Try with TRUNC({trandate})
t
Thomas
03/03/2020, 8:27 PMgiving me 1
Thomas
03/03/2020, 8:27 PMon every user
g
Gregory Jones
03/03/2020, 8:34 PMeven with the TRUNC() around trandate?
a
Aria Ghahari
03/11/2020, 8:41 PMWhat is the value you are putting after THEN? i.e. when {trandate} = to_date(TRUNC({today}, -1)