Standard formatting (also conditional) will always be applied to the
current column/row based on the data in that column/row. It does not
matter if the data is comming from a POV in the cube or from a
calculation in the cubeview. If think referring i...
Hi Will, you can use e.g. a U8# member and put a dynamic calc on it to
return 0. In the formula you can also define for which cases / amount
ranges you want to show 0 (e.g. < 0.01 or > 0.01). This can alos be used
to show 0 in case of NODATA. Dim dAm...
I have a smilar issue. Changing these settings does not reduce the time
to refresh the workbook. Also if I populate lots of cells (ca. > 100) in
the CV in Excel it takes very long that the cells get yellow (indicating
that data is not in DB). When I ...