Oct 31 2021 12:05 PM
I have a CUBERANKEDMEMBER() calculation which I found will spill nicely over a CUBESETCOUNT() sequence. I now want to spill a CUBEVALUE() calculation based on the generated list. It just throws a non spilled single cell #N/A. Should I expect the CUBEVALUE to spill or is this something that wont work? The formula works as a single cell so its all okay from that POV, its just the spillability of it that's not working.
Nov 01 2021 05:10 AM
I didn't test myself, but based on
and comments to above, you can't do spill with CUBEVALUE(), only using MAKEARRAY()
Nov 01 2021 11:19 AM