We are using row and column templates to make Hyperion financial reports. But the problem is when you insert a row template and choose the columns that you want, it does not let you do conditional formatting (like decimal places, numbers in %, creating boxes/columns etc.). Only when we unlink it you can do all the formatting.
But, we want to use row and column templates because it will help in long term maintenance, when we need to update any new member. Unlinking the templates to do formatting will not solve the long term purpose.
Please advice what is the best way to do this, so that we can use row and column templates as well as do the required formatting.