Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=FirstSortedValue([Core Product], -[Transaction Date])
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?
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
Thanks Sunny for your help, that is exactly what I wanted.
Awesome
No worries Jordan