Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use variable as offset in Class function?
I create dimension:
=Class(
sales,
0.05,
'x',
$(vMinSales)
)
vMinSales: Min(Aggr(sum(sales), myDimension))
But it doesnt work - Invalid dimension error.
Yes, it's possible but the variable must return a dimension or a value and not an expression. In your case I'm not sure that defining the fourth parameter will be very useful. Beside this the following might be what do you looking for:
Class(sum(sales), 0.05, 'x', $(=vMinSales))
- Marcus