Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago

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...
Need Help
netanel's avatar
netanel
Post Prodigy
4 years ago

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

 

lbendlin's avatar
lbendlin
Super User
4 years ago

Please update your sample file with the account reference.

  • netanel's avatar
    netanel
    Post Prodigy
    4 years ago

     

    updated

    + column Agg(+,-) in Dim Account

    Thanks

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      fact table is still empty

       

       

      • netanel's avatar
        netanel
        Post Prodigy
        4 years ago

        Sori,
        updated