Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
now i have such formula :
sum({<Year={'$(=max(Year)-1)'}>} [liters purchased])
so when i have selected Year 2011, this formula me returns previous year 2010, not looking that i have selected Y2011. - it's OK.
now i want to add additional rule , also that should not look at selections. i have Local or Export sales, so i would like to add additional rule in this formula , is it possible ? so should be something like that : {<Year={'$(=max(Year)-1)'}>} { .... local...} [ liters purchased] .. ?
hei
yes you can add as much conditions as you like
it will look like
sum({<Year={'$(=max(Year)-1)'},KindOfSales={"local"}>} [liters purchased])
hei
yes you can add as much conditions as you like
it will look like
sum({<Year={'$(=max(Year)-1)'},KindOfSales={"local"}>} [liters purchased])
Super, Thanks !
it works 🙂