Calculate net profit

[mustafaelryah]

Dear All,

     I have chart that shown all expenses vs all revenues , I need to show (revenues - expenses) on Text Object.

My dimension is account type , my expression calculate only summation of expenses or summation of revenues.

[arulsettu]

try this

in text object

=sum(revenues)-sum(expenses)

[mustafaelryah]

Kindly see how I calculated the  expenses and revenues

=if ( Account_Type2<> 'Equities' and  Account_Type2<> 'Assets' and Account_Type2 <> 'Other' and Account_Type2 <> 'Liabilities',if(Sum(debit) - sum(credit)>=0,Sum(debit) - sum(credit),-1*(Sum(debit) - sum(credit))))

and what can I do on text object?!