Calculating total percentage in Straight table

[markgraham123]

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.

Please see the attachment.

Can someone look into this?

[sunny_talwar]

See attached

[markgraham123]

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.

[sunny_talwar]

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

[markgraham123]

Sunny,

Here is the application with exact situation.

I was able to get the percentage only for dimensions.

But not fro total.

[MK_QSL]

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..