Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I use the following expression in order to ignore year , month week and day filters , but when I choose a year the values change . How to modify it ?
((Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"},Year=,Month=,Week=,Day=>} [Prix de vente TTC]))/28 )* count(distinct Date)
((Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"},Year=,Month=,Week=,Day=>} [Prix de vente TTC]))/28 )* count({{$ <Year=,Month=,Week=,Day=> }distinct Date)
let me know
((Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"},Year=,Month=,Week=,Day=>} [Prix de vente TTC]))/28 )* count({{$ <Year=,Month=,Week=,Day=> }distinct Date)
let me know