Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I'm using the following expression to color my bars depending on its value...
If it's above the TTOAL average (red), otherwise (green)
IF(AVG(TOTAL FSPLU) > AVG(FSPLU), color(3), color(2))
But, in this case, if the user selects some bars, the system will recalculate the colors again based on the available remaining bars.
How can do not change the colors in this case?
I mean, once it's calculated the colors should not change anymore upon users' selection.
Would that be as simple as replacing the TOTAL by ALL?
IF(AVG(ALL FSPLU) > AVG(FSPLU), color(3), color(2))
Thanks
You will still need TOTAL
IF(AVG({1} TOTAL FSPLU) > AVG(FSPLU), color(3), color(2))
{1} and ALL are the same. ALL was deprecated when replaced by {1} and ALL was meant to be removed from the product. However, the removal never happened.
-Rob
So, do you want to compare the overall AVG with currently selected AVG?
IF(AVG({1}FSPLU) > AVG(FSPLU), color(3), color(2))
You will still need TOTAL
IF(AVG({1} TOTAL FSPLU) > AVG(FSPLU), color(3), color(2))
{1} and ALL are the same. ALL was deprecated when replaced by {1} and ALL was meant to be removed from the product. However, the removal never happened.
-Rob