Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i need to find Max Date with expression comparing of 2 field but both these fields are Calculated dimensions.
Thankyou
Try this
=RangeMax(Cal_dim_expr1,Cal_dim_expr12)
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
Thank you anbu1984, MDMUKRAMALI