Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
5 years ago

Revenue and Expense

Hello,

 

I have a Income Statement report that shows revenue as a positive number and expense as a positive number and the total Or Net income properly calculates revenue - expense.

 

 

The formula is 

Amount = IF(sum('00-GL10Year'[Revenue]) > 0 ,[Credit] - [Debit],[Debit] - [Credit])
 
The problem is that if there are noi revenue records and ONLY expenses I am getting a positive number when really I should be getting a negative number:
 
 
 

How can I get this expense to show as a negative number?  

 

Need Help

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    lcasey why you are doing this Amount = IF(sum('00-GL10Year'[Revenue]) > 0 ,[Credit] - [Debit],[Debit] - [Credit])

     

    why not just do [Credit] - [Debit]

    • lcasey's avatar
      lcasey
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Hello,

       

      Becouse then the expense numbers are shown as a negative, and if there is a credit (negative number) to the expense account it shows positive which is wrong:

       

       

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    lcasey you can use ABS function to change negative to positive in your calculations, there are many ways to address it. You need to put together a simple calculation on how you want to see it.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi lcasey ,

    I have some doubts. According to your description, when it is expense column, the corresponding value should be negative number. There are some problems with this part of data in your table. I want to know how your total comes from. Can you provide more data or information for me to test you?

     


    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.