Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guyz ,
I need Help here is my Question
i have a field for example
Renuwel Date
5/25/2015
4/31/2015
3/12/2015
i need to calculate the Count of [Renuwel Date] it is Greater than [Today()]
How can i write this in a set analysis
Thank you,
=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])
BTW:
Duplicate
Hi mario,
test this in a textbox on the GUI first. That way you can easily tell whether it works or not.
To do something like this, you need a way to compare this date with the output of the function > Today() <.
If it doesn't just work like that, the DATE#() function should help there - or you re-format your date in the script.
HTH
=count({<[Renuwel Date] = {">$(=(today()))"} >}[Renuwel Date])
=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])
I understand this is a month old post, but I all seeing the highlighted part for the first time. Would you be able to share some information about it?
Thanks,
Sunny
Hi,
Try like below
=Count({<[Renuwel Date] = {">$(=Today())"} >}[Renuwel Date])
Note: [Renuwel Date] and output of Today() should be in the same format.
Regards,
Jagan.
=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])