5 Replies Latest reply: Jan 7, 2016 6:07 PM by Manish Kachhia

# Calculating total percentage in Straight table

Hello Everyone,

I created a straight table in which i have Income1, Income2, Expenditure1, Expenditure2 fields.

I calculated Income1+Income2 in one expression.

Expenditure1+Expenditure2 in another expression.

Then, i calculated percentage of expenditure in income.

But i'm getting the percentage for total income and total expenditure.

Can someone look into this?

• ###### Re: Calculating total percentage in Straight table

See attached

• ###### Re: Calculating total percentage in Straight table

Well, it's working in this sample app, but in my original application in which i'm using Pick(Match(Value(List()) is not working sunny.

Thank you for your help sunny

I think it doesn;t work when we have pick match value used in the expressions.

• ###### Re: Calculating total percentage in Straight table

Would you be able to share your application which has that formula or may be a sample?

• ###### Re: Calculating total percentage in Straight table

Sunny,

Here is the application with exact situation.

I was able to get the percentage only for dimensions.

But not fro total.

• ###### Re: Calculating total percentage in Straight table

If you A1 = A, B1=B and C1=C, you can use something like below..

pick(match(ValueList('A1','B1','C1','D1'),'A1','B1','C1','D1'),Only({<ID={'A'}>}Income)+Only({<ID={'A'}>}Income2),

Only({<ID={'B'}>}Income)+Only({<ID={'B'}>}Income2),

Only({<ID={'C'}>}Income)+Only({<ID={'C'}>}Income2),

Only({<ID={'D'}>}Income)+Only({<ID={'D'}>}Income2))

Same way you can calculated Expenditure..