Max of Year Quarter Base

[Purushothaman]

Hi Experts,

How to get the Max of the   Year Quarter Base  for this Data Type. 

Anyone, Please help!!

Thank you!!

[justISO · Accepted solution]

Hi, it depends on structure of this [Year Quarter Base] field structure, how it is made, is combination of multiple fields or just string. If string, maybe this solution can be used to present max dimension:

=if( Num(KeepChar([Year Quarter Base],'0123456789'))=max(total Num(KeepChar([Year Quarter Base],'0123456789'))), [Year Quarter Base])

[Mark_Little · Accepted solution]

Hi.

Probably something like 

SUM(AGGR(MAX(Value),[Year Quarter Base])).

Value being the field you want the max from

[Purushothaman · Accepted solution]

Max String