Alternate for FirstSortedValue Function.

[Somasundaram]

Hi,

I am using firstsortedvalue function for getting date value. I have saved as a variable and using multiple places, some of the time I am getting the wrong value. One place is showing correct and another place is showing wrongly.

Is there any way to implement firstsortedvalue functionality with out using firstsortedvalue function?

Help would be appreciated.

Regards,

Somasundaram

[sunny_talwar]

There is... you can use Aggr() with if statement to do it...

[Somasundaram]

Can we use nested Aggr() function?

[sunny_talwar]

I would think so... not sure what you have so cannot really say with confidence 🙂