Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've set up a date selector that allows users to enter a to and from date for which data will be displayed. I would now like to make a comparison between the date range they've entered and the previous period relative to this date range. For instance, if they enter 12/20/2011 to 12/30/2011, I would like to show the figures for 12/9/2011 to 12/19/2011 in another column.
I've seen similar things done with the addmonths fuction, but have not been able to find a way to do it with days.
I've attached the example I'm working with. If anyone has any insight, it would be greatly appreciated.
Best,
Matt
hei check the attach example
i added a varaible of days diff
and used it in thep previous expression
hei check the attach example
i added a varaible of days diff
and used it in thep previous expression
Hi Liron,
Thanks so much for the help, works perfectly!
Matt
Hi Hope this helps!
PFA