Find Max date of 2 fields

[#1]

Hi All,

i need to find Max Date with expression comparing of 2 field but both these fields are Calculated dimensions.

Thankyou

[anbu1984 · Accepted solution]

Try this

=RangeMax(Cal_dim_expr1,Cal_dim_expr12)

[mdmukramali]

Dear,

can you check the below example.

Load * Inline

[

Forecast1,Event1

10/18/2012,05/08/2012

09/06/2012,05/14/2012

09/28/2012,07/25/2012

10/25/2012,08/22/2012

10/10/2012,11/11/2012

]

;

Dimensions

Forecast1

Event1

Expression:

=if(Num(Forecast1)>Num(Event1),Forecast1,Event1)

But as you mentioned you have calculated dimension . so try to use the calculated Dimension syntax in the expression.

else attach the sample file for better understanding.

Thanks,

Mukram

[#4]

Thank you anbu1984, MDMUKRAMALI