Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if(sum({$<Year={'$(=max(Year))'}>}Sales_amount)>12.00,green(),red())=====while evaluating this expression showing only first color for all the values.
Hi
Try like this
=if(sum({$<Year={'$(=max(Year))'}>}Sales_amount) / sum({$<Year={'$(=max(Year))'}>}Total Sales_amount) >0.12,green(),red())
Hi
Try like this
=if(sum({$<Year={'$(=max(Year))'}>}Sales_amount) / sum({$<Year={'$(=max(Year))'}>}Total Sales_amount) >0.12,green(),red())
Thank you.