Use of Min in calculated dimension

[martynlloyd]

Can anyone tell me why I can't use Min(adate) in a calculated dimension?

='Contract End from ' &  ' ; Contract Types ' & GetFieldSelections([Contract Type])

works fine,

but

='Contract End from ' & min([Contract End]) &  ' ; Contract Types ' & GetFieldSelections([Contract Type])

Does not.

Regards,

M

[martynlloyd]

It's in the variable overview, but it doesn't change, and has a date of 1899

regards,

M.

[JonnyPoole · Accepted solution]

I didn't hear it but i think you are going for a min date across all records in the current selections, not a dimensional mininmum. if that is the case this works in your sample as well:

=date(Min( total EndDate)) 

[martynlloyd]

Thanks, adding TOTAL solves my original issue as well.

Regards,

M.