Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have to highlight the Row value of Limit1 or Limit2 based on which limit value we are using for calculating Limit %.
Limit % calculation based on below condition:
If todays date > expiry date , actualvalue /Limit 1,actual value/ Limit2
So if we are using Limit1 or Limit2 for calculating limit % value that value needs to be highlighted.
Hi,
I don't understand you question. Can you explain how your data looks like and explain more about when you want to highlight. Is "actualvalue" the same as "actual value"? Is "Limit 1" and "Limit 2" two data fields?