Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can somebody please help me to get the expression in a text object to calculate the share of profit contributed by Shirt category in %.
category | Profit |
Shoe | 500 |
Tablets | 3000 |
Mobile | 500 |
Shirt | 1000 |
Sum(Profit)/Sum({<Category={'Shirt'}>} Profit)
Sum(Profit)/Sum({<Category={'Shirt'}>} Profit)
It worked with a little modification.
=Sum({<Category={'Shirt'}>} Profit)/Sum(Profit)*100 & '%'
Thank You!
=Sum({<category={'Shirt'}>} Profit)/sum( total Profit)*100&'%'