Total Function

[sunil-kumar5]

Hello Everyone,

I have measure sum(Debit)-sum(credit) and I want a result per below, I am using Total function to meet it but no success, however total function always works with set analysis but don't know why it is not working with this measure. Please let me know how I can achieve the contribution %?

Requirement

Item	Measure(sum(Debit)-sum(Credit))	Contribution%(Item/Total of all item)
Total	10000	100%
TO SUBSCRIPTION & SUPPORT CHARGES	1000	10%
TO CONVEYANCE EXPENSE	4000	40%
TO TRAVELLING & TOUR EXP.	3000	30%
TO BUSINESS PROMOTION	2000	20%

Please Advise.

Thanks

[tresesco]

How exactly are you writing the contribution expression? 

[sunil-kumar5]

I have tried like below:

(Sum(Debit)-Sum(Credit))/ Total(Sum(Debit)-Sum(Credit))

[tresesco]

Total is not a function but a qualifier. It needs to be in aggregation function. Try like:

(Sum(Debit)-Sum(Credit))/(Sum(Total Debit)-Sum(Total Credit))

[sunil-kumar5]

I tried this as well but no luck

[Kushal_Chawda]

@sunil-kumar5  try below

(Sum(Debit)-Sum(Credit))/sum(total aggr(Sum( Debit)-Sum(Credit), Item))

[sunil-kumar5]

Hi,

Actually I am getting the item value by using below function as there were many things and I only want few.

IF(NOT MATCH(DLNo,'ADMIN EXPENSES','ADVERTISEMENT @ PROMO','BUSINESS PROMOTION','EMPLOYEE BENEFIT',
'FINANCIAL EXPENSES','IT EXPENSES','OTHERS NOT FOR BUSINE','PARTNERS','REGIONAL OFFICE','SKILL','TRAVELLING')=0,DLNo))

Then how I can apply this?

Thanks