Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm dealing with a request from management. My goal is to create a pixel perfect PDF report so that in the last column showing the totals, this is colored according to a color gradient from green to red.
The table shows the first 30 products ordered from most consumed to least consumed. The last column measures the deviation with respect to price and quantity changes (management control).
On the QS app I solved it easily like this:
Colormix1(
Rank(r_Overall_effect_variance, 0, 1) / 30,
RGB(255, 0, 0), // Red for lowest value
RGB(0, 255, 0) // Green for the highest value
)
How can I do it the same way on pixel perfect?
within the formatting rules there is neither the color mix function nor the Rank function.
Thanks!
Hi.
First make sure you are providing us correct information:
Regarding conditional formatting in Pixel Perfect.
Lastly I would probably build it based on excel template with PDF output (which effectively is a print of excel to PDF) and use excel conditional formatting as it would be so much easier:
cheers