Forum Discussion
P&L Help +- & Sort
Hi community, Two questions I'm having trouble with I have a financial statement the Description in the table come from an Dim account The amount comes from the FACT table Everything is connected...
1. Add a calculated column that inverts the sign for the fees but keeps it for the revenues
2. Create a reference table with the sections and their desired sort order as an index. Then use "Sort one column by another column"
The fact table seems to be missing the account reference?
Hi lbendlin
I am trying to create a correct plus and minus sign in my numbers
I have an agg(+,-) column where the signs are correct
And I have an Amount column.
Because when I multiply between them something falls
The logic of the measure says Amount * Agg (column sign)
The rest of the formula is ignoring other filters