Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Is it possible to use Dimensionality() with calculated dimensions?
The below formula works if I have fixed dimensions Division and Specialty, but if I use
=pick($(vDimension1), Division, Specialty)
to select the two dimensions, it doesn't seem to work. Help!
if (Dimensionality() = 1, NUM(count({<AttendStatus = {"Attended"}>} distinct [EmpNo])/count ( total <Division> distinct [EmpNo]),'0.00%'),
if (Dimensionality() = 2, NUM(count({<AttendStatus = {"Attended"}>} distinct [EmpNo])/count ( total <Division,Specialty> distinct [EmpNo]),'0.00%'),
NUM(count({<AttendStatus = {"Attended"}>} distinct [EmpNo])/count ( distinct [EmpNo]),'0.00%')))
Thanks
Sarah