Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to show some values like:
User Logged in Today:
User Logged in Yesterday:
.....
and these values will no change when any selection is made in the document.
My table People has fields:
UserID Last_Login LASTLOGGEDINDATE_Num
1 8-Jan-2014 41647
2 8-Jan-2014 41647
3 7-Jan-2014 41646
an so on.
I need to show a table like following when the document is loaded. User will be clicking on any of the other fields but these values should not change.
Logged in Today: 2
I have set up a variable: v_current_date_num=num(today())
and using this variable in the following calculation: count({$< People.LASTLOGGEDINDATE_Num={'=$(v_current_date_num)'}>} UserID).
This does not seem to work as the value this shows depends on what date is selected.
appreciate any help on this.
thanks.
Maybe without the single quotes and equal sign and with set identifier 1
count({1< People.LASTLOGGEDINDATE_Num={$(v_current_date_num)}>} UserID)
Maybe without the single quotes and equal sign and with set identifier 1
count({1< People.LASTLOGGEDINDATE_Num={$(v_current_date_num)}>} UserID)
Hi
Try this in your expression
=Count({1<FieldName={'$(VariableName)'}>}UserID)
In your Case:
=count({1< People.LASTLOGGEDINDATE_Num={'$(v_current_date_num)'}>} UserID)
Hope this helps
Regards,
Manideep
Thanks Swuehl. That works.