Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need help.
I have a table as below:
Tab1:
ID, DateX
1,25/01/2012,
2,01/11/2013,
3,21/10/2012,
4,22,03/2014
5,31/01/2014
And I have a variable(vMthMax) which stores date.
__________________________________________________________________
What I need is: total count of the records matching and unmatching in that table where =
if DateX IS NOT NULL AND DateX <= vMthMax.
Thanks,
Lakshmi.
maybe something like this:
Hi Danial,
Thanks for the reply, Can I ask one thing?
Irrealavent of selection of month or year or day...
how do I get total count of the records where <= (vMthMax) from my table? Is it possible?
i.e. eventhough user selects, month, year, my vMthMax will not change, and i want records where <= (vMthMax).
Thanks.
Can any one help me on this?
Irrealavent of user selection on dashboard (e.g. month or year or day)...
how do I get total count of the records where <= (vMthMax) from my table? Is it possible?
i.e. eventhough user selects, month, year, my vMthMax will not change, and i want records where <= (vMthMax).
You could use this in your expression (see matching 2)
count({<DateX={"<=$(vMthMax)"}, Month=,Year=>} total ID)
Please find example attached