Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Problen with sum
In the first column I would like to have sum with sum date 2017-05-01and in the other column sum date 2016-05-01
ex
how big was sales, last year at a specific date
//Janne
May be this?
Sum({<DateField = {'$(=AddYears(Max(DateField),-1))'}>} Sales)
What is your chart dimension here?
I have tried that variant but it will only be 0
//=Sum({<Date = {'$(=AddYears(Max(Date),-1))'}>} sales)
21767454,82->2016-05-01
3201530,09 ->2017-05-01