Need to fix this expression for dimension expression.

[wiz_nerd]

=if(aggr(rank(if(not IsNull(fieldversion), fieldVersionDate)),groupname,fieldVersionDate) < 2,fieldversion)

I have this dimensional expression however the number of fieldversion result depends on  the "number" which is 2 in this expression.

however the scenario is the sometimes the fieldversion is empty with respect to field version date and so there are no  values. and sometimes its 2 as max return here is 2.

but I want only one last output of fieldversion in the dimension so for any value of number if there are n output I need only one last output  of fieldversion with respect to field version date..... per group name. 

[rubenmarin1]

Hi, I'm not sure to understand your issue... note that aggr will return  value for each combination of groupname and fieldVersionDate, maybe you need to count returned values for aggr:

=if(Count(aggr(rank(if(not IsNull(fieldversion), fieldVersionDate)),groupname,fieldVersionDate)) < 2,fieldversion)