Overriding a format template
I have a dataview report very similar in nature to a standard P&L type view, on my rows I have various measures which need formatting differntly for example row 1 is a dollar value to zero decimal places, row two is a percentage to 1 decimal place and row three is a dollar value to 2 decimal places. Column 1 is current week, column 2 is prior week and column 3 is a variance of the two in percentage, however the Var column is adopting the format of the rows that has been set by the template. I can't find a way of overriding the format template so that my var columns are always as % and 1decimal place. Can anyone help on this?
Answers
-
Hello Adam,
you can try to make it using block formatting and the row template. Consider that the row template is always applied at last, so it will override the block formatting. One solution can be to apply the symbol formatting on the blocks that you wish, and override it only for the second row with the row template. Set the digits in the block only for the variance %, and override that on the row template. See screenshots for the details. With this configuration, there will be one cell of the variance % which will have a wrong number of digits anyway. This is the easiest solution you can find, which still is not perfect.
On the other hand, if you have a fixed selection, you can use Nexel on deepest entity rule, or apply a detail by on the cubes and not to the algorithm. That way, you can apply a row formatting on the value and another one on the totals. But still with these two alternatives, you need to be very careful on the selections that can be applied on the screen that could mess up your formatting.
9
