Good day all,
I've been experimenting with the Diff Past Month functionality in a widget to track our On Account funds. But rather than a "rolling month" (or "a month from today" which I think is what i get with this formula), I'm looking for a difference from a fixed date, so for example 8/31/21.
Is that possible?
Thanks!
Lesley
Hi Anh,
Are you intending that this show the difference as an indicator widget, or is this in the context of some other visualization? For an indicator the formula could be constructed as the grand total minus the total prior to your specific date. E.g.
[Total Whatever] - ( [Total Whatever] , [Days in Date w/Calendar type filter From Earliest Date To 8/31/21] )