Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a daily observations of active accounts (activeacnts). I would like to do two things with them.
1. Put activeacnts today in Text box
2. Plot active accounts on the last day of each month in a line chart.
I tried to use set analysis to accomplish this but I cant seem to understand the formatting requirements. e.g. For today's activeacnts I did this
Sum({$<Date= {'=Date(Today())'}>}activeacnts)
It gives me sum of all the active accounts instead of active accounts Today. if I write
Sum({$<Date= {'8/2/2012'}>}activeacnts)
Then I get correct answer.
Similarly when i create Expression to plot monthend active accounts I get weird numbers on the line chart. I am not able to understand what's going wrong.
Hi
Your date format is 'M/D/YYYY' ? If so, you can use like this,
=Sum({$<Date= {"$(=Date(Today(),'M/D/YYYY'))"}>}activeacnts)
I think ,your format is MM/DD/YYYY only..
=Sum({$<Date= {"$(=Date(Today(),'MM/DD/YYYY'))"}>}activeacnts)
Hope it helps
Hi
Try like this
=Sum({$<Date= {'$(Date(Today()))'}>}activeacnts)
But make sure the format. Date(Today(),'MM/DD/YYYY')
Hope it helps
How to make sure of that, Mayil? I think my date format by default is 'M/D/YYYY'
Hi Samarth,
Try this.
=Sum({$<Date= {"$(=Date(Today(),'MM/DD/YYYY'))"}>}activeacnts)
Hope this will Help.
Regards,
Kaushik Solanki
Hi
Your date format is 'M/D/YYYY' ? If so, you can use like this,
=Sum({$<Date= {"$(=Date(Today(),'M/D/YYYY'))"}>}activeacnts)
I think ,your format is MM/DD/YYYY only..
=Sum({$<Date= {"$(=Date(Today(),'MM/DD/YYYY'))"}>}activeacnts)
Hope it helps