Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Friends ,
I am writing a calculated dimension
=only({<[%KPI_KEY]={'ARIEL'},Metric=}>}if((DATE <= END_DT and DATE >= EndMonth13 ),MonthYear))
it doesn't throw error instead says invalid dimension. Can anyone help ?
Make sure all fields being used in the expression do exist in the data model.
Can you provide a sample app?
Try this:
Aggr(only({<[%KPI_KEY]={'ARIEL'},Metric=>}if((DATE <= END_DT and DATE >= EndMonth13 ),MonthYear)),MonthYear)