Hi!
We having big MFUs in office and Office Manager need to know daily and monthly printed pages quantity to calculate expenses.
For this I need to compare item with it's one month old value.
Formula I use for daily calculations: last(pages_printed_total) - last(pages_printed_total, #1, 1d)
But it's not applicable for monthly calculation, as number of days may vary.
So basically I just need to know how to change Day (d) to Month. Spent some time for googling this and reading through forum, but found nothing. Tried to use M, m, mo and so on - works only with m, but it indicates minutes, not months. Other statements make item unsupported.
Is anybody know how to do this?
Help is much appreciated.
Thanks you!
We having big MFUs in office and Office Manager need to know daily and monthly printed pages quantity to calculate expenses.
For this I need to compare item with it's one month old value.
Formula I use for daily calculations: last(pages_printed_total) - last(pages_printed_total, #1, 1d)
But it's not applicable for monthly calculation, as number of days may vary.
So basically I just need to know how to change Day (d) to Month. Spent some time for googling this and reading through forum, but found nothing. Tried to use M, m, mo and so on - works only with m, but it indicates minutes, not months. Other statements make item unsupported.
Is anybody know how to do this?
Help is much appreciated.
Thanks you!
Comment