Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression work fine , it display the higher value with dark color :-
$(vPriceBookRatio)
-$(=min(aggr(
$(vPriceBookRatio)
,COMPETITOR_K))))
/
$(=(max(aggr(
$(vPriceBookRatio)
, COMPETITOR_K))
-min(aggr(
$(vPriceBookRatio)
, COMPETITOR_K)))),lightgray(),green())
Now my requirement have change , the smaller value mean better , so How to change the color sequences the other way round ?
Paul
Paul
Colormix1((
$(vPriceBookRatio)
-$(=min(aggr(
$(vPriceBookRatio)
,COMPETITOR_K))))
/
$(=(max(aggr(
$(vPriceBookRatio)
, COMPETITOR_K))
-min(aggr(
$(vPriceBookRatio)
, COMPETITOR_K)))),green()),lightgray())
Colormix1((
$(vPriceBookRatio)
-$(=min(aggr(
$(vPriceBookRatio)
,COMPETITOR_K))))
/
$(=(max(aggr(
$(vPriceBookRatio)
, COMPETITOR_K))
-min(aggr(
$(vPriceBookRatio)
, COMPETITOR_K)))),green()),lightgray())
my QVF
Wow you are good , with out look at my app , you can directly give me correct answer.