Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I need to display a data in Text object based on the value of the background color of the text object should change and in the text object I need to display the sum of Sales(Actual) for a given product in the text object with appropriate background color
If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is less than 60% the background should be in Red color
If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is greater than 85% the background should be in Green color
If the value of the Sum(ActualSales)/Sum(PlannedSales) for a given product is between than 60% & 85 % the background should be in Yellow color.
I have attached the Sample Data for the same.
Any help in this regard is appreciated
Thanks in Advance
PFA
May be like attached sample
Dear,
Kindly find the attachment.
Thanks,
Mukram.
Thanks Nizam,tresesco,Mukram for your timely help.
All the three worked..:)