Set Analysis on a string value

[#1]

Hi,

I need to be able to do set analysis on a string.

I have a string value called Core Product which is a "Yes" or "No" field. I need to be able to do set analysis / filter based on a Transaction Date field to be able to get the latest record.

EG:

Transaction Date               Core Product

01/02/2016                         Yes

03/02/2016                         No

05/02/2016                         Yes

I need to be able to get the last record..

Because Core Product is a string, I am unable to use sum or max.

What should I use?

Thanks

Jordan

[sunny_talwar · Accepted solution]

Try this:

=FirstSortedValue([Core Product], -[Transaction Date])

[#3]

Hi Jordan,

Can you please explain more about what you are trying to achieve? I am little confused and don't want to give incorrect solution.

What last record you want to get? Latest date when a Core Product was YES? or Total of core products?

[#4]

Hi Lokesh,

Sunny has answered my question, thanks though.

I was wanting to get the newest Core Product based on the latest transaction date. In my example it would be 05/02/2016 - Yes.

Thanks

Jordan

[#5]

Thanks Sunny for your help, that is exactly what I wanted.

[sunny_talwar]

Awesome

[#7]

No worries Jordan