We flip the sign for liability and revenue type accounts in FDM and utilize account type. We then want to generate a trial balance which shows the proper debit and credit signs.
I typically advise to perform this in FR reports especially if the client is using the [Elimination] and/or [Contribution Adjs] value dimensions and wants to generate a sub consolidated trial balance because you can hide all these columns and simply create an "elimination" formula column.
The problem is that when you extract such a report into excel, the formatting caries what is truly in the database and ignores conditional formatting. Wondering how others work with this?
Two other potential options:
Create a custom dimension member (aggregation weight = 0) which flips the sign for liability/revenue accounts using an HS.EXP rule. Bad side is this is stored data which adds time to the consolidation.
On demand rule in a web form to flip sign. Problem with this is you can't suppress columns, so you will have 20 entities [Elimination] and [Contribution Adjs] members, creating an ugly report.