Set Analysis-calculated value that should not change on selection

[amit_shetty78]

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.

[swuehl · Accepted solution]

Maybe without the single quotes and equal sign and with set identifier 1

count({1< People.LASTLOGGEDINDATE_Num={$(v_current_date_num)}>} UserID)

[manideep78]

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

[amit_shetty78]

Thanks Swuehl. That works.