Period of sales of current month compared with last month acording to current month progress

AppSheet AppSheet Q&A
,
1

how to show a column that gets the percentage of growth or decline of sales of current month compared with previous period of last month?

for example today is feb 18, I would like the expression to get the sales of current month and then compare it with the same period of last month.

(jan 1 - jan 18)

to get sales of current month in a slice Im using this

EOMONTH([Date], 0) = EOMONTH(TODAY(), 0)

any help is much appreciate it.

2

For last month’s slice, please try an expression, something like

AND(EOMONTH([Date], 0) = EOMONTH(TODAY(), -1) ,

DAY([Date])<=DAY(TODAY()))

1 Like