Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm really struggling with this issue.
I have some data that displays some data based on month selected. I would also like to get the data to display the previous months data. In my example I have 2 tables, one has it working if I hard code the month, the other is not working, when I try an use the variable.
I would really appreciate any help you offer with this.
Cheers
Simon
do not hard code any thing make it flexible and dynamic
please see below expression for current month and previos month
current month :
=sum({<year={$(=max(year))}>},month={$(=max(month))}>}amount)
previos month :
=sum({<year={$(=max(year))}>},month={$(=max(month)-1)}>}amount)
Regards
Anant
Hi,
Thanks for replying so quickly.
We know not to hard code anything, which is what we are trying to avoid.
All I want to know is why it will work when we hard code the text, but when we use a variable which contains the same value, it does not?
Cheers
Simon
Hi ,
Here is the attached file for your issue.
Regards,
Udit
Hi,
check the attached file
Hi,
Thanks for this, I can stop pulling my hair out now!!
Much appreciated.
Cheers
Hi,
Thanks for this, I can stop pulling my hair out now!!
Much appreciated.
Cheers
Hi,
THank you to everyone thathelped me with this originally. Its been working a treat.
However I decided to create my dates a different way based on the data instead of a fixed table, which all works fine, but it has broken the way I get the previous data.
I've tried all sorts but cant get it to work.
I would really appreciate it if someone could help get it working again, and also explain to me why it works, so I have a better understanding if I brake it again.
Cheers