ContributionsMost RecentMost LikesSolutionsRe: Conditional Formatting to Show "0" 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 ...Re: Conditional Formatting to Show "0" Correct, I'd suggest to update the formula on that UD8# member to check the calculated value and adjust it (round or set to 0) before returning it. Re: Conditional Formatting to Show "0" 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 ca...Re: Optimize CubeView performance in Excel 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 ...