Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
See attached
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.
Would you be able to share your application which has that formula or may be a sample?
Sunny,
Here is the application with exact situation.
I was able to get the percentage only for dimensions.
But not fro total.
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..