Display Current Month Selected

[Anonymous]

I have a line graph that displays all months selected and also a test box that should only display the amount for the most recent month selected.  What is the expression that could make this work?

Here is what I have but it is pulling YTD not just the amount in the last month.

Sum({$<[acct month] = {$(=Max([acct month]))},[acct year] = {$(=Max([acct year]))} , [acct month] = >} [trans amt])

[Sokkorn]

Hi,

Maybe you can consider this function:

GetFieldSelections (FieldName [, ValueSep [, MaxValues]])  -> Returns a string with the current selections in a field. ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

Regards,

Sokkorn

[jonathandienst · Accepted solution]

Hi

I suspect that the second assignment for [acct month] is overriding the first. Try

Sum({$<[acct month] = {$(=Max([acct month]))},[acct year] = {$(=Max([acct year]))}>} [trans amt])

This expression assumes that [acct month] is a numeric field with the month number.

Hope that helps

Jonathan

[Anonymous]

That worked! Thank you!