Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
in text object
=sum(revenues)-sum(expenses)
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?!