Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want in sell through column if I want to show sell through percentage in different color
if I have sell through percentage between 40 to 60 per then background color should be orange
if i select sell through percentage below 40 then background color should be red
if I want sell through percentage above 60 then background color should be green
Following is the code for the same.
=if(num(
(sum( {stateperfB<Sold_Date = {">=$(sstart)<=$(eend)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {stateperA< Sold_Date = {">=$(sstart)<=$(eend)"}, [Season Code] = {$(MasterCurrentSeason)}>} quantity_returns))
/
sum( {stateperfB<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received)
,'#,##0%')>='60%',Green(),
if(num(
(sum( {stateperfB<Sold_Date = {">=$(sstart)<=$(eend)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {stateperA< Sold_Date = {">=$(sstart)<=$(eend)"}, [Season Code] = {$(MasterCurrentSeason)}>} quantity_returns))
/
sum( {stateperfB<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received)
,
'#,##0%')<'40%',RGB (255,0,0),
if(num(
(sum( {stateperfB<Sold_Date = {">=$(sstart)<=$(eend)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {stateperA< Sold_Date = {">=$(sstart)<=$(eend)"}, [Season Code] = {$(MasterCurrentSeason)}>} quantity_returns))
/
sum( {stateperfB<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received)
,
'#,##0%')='-%',white(),RGB(255,128,0))))
Hi,
In expressions tab, when you expand the expression for the column, you'll see an option called "Background Colour"
select that and use the below sample script. Pls modify the fileds accordingly. Also the RGB values.
ColorMix2 (
if(rangemin(.5,rangemax(Sum (Margin)/Sum (Sales),-.5)) < 0,
-Sqrt(-(rangemin(.5,rangemax(Sum (Margin)/Sum (Sales),-.5)))/(-.5)),
Sqrt((rangemin(.5,rangemax(Sum (Margin)/Sum (Sales),-.5)))/(.5))),
ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0), ARGB(255, 255, 255, 255))
Here I am not getting the correct color which I want
I want red color when value is below 40%
i want orange color when value is between 40 % to 60 %
I want green color when value is above 60 % sell through value
i am using following code in background color option. please help
ColorMix2 (
if(rangemin(.5,rangemax((Column(1)/column(2)),-.5)) < 0,
-Sqrt(-(rangemin(.5,rangemax((Column(1)/column(2)),-.5)))/(-.5)),
Sqrt((rangemin(.5,rangemax((Column(1)/column(2)),-.5)))/(.5))),
ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0), ARGB(255, 255, 255, 255))
Please help
I want the value under sell through column should be presemted in different color
If value is below 40 per then value should be red
above 60 per green and between 40 -60 per should be orange
but here i am gtting only one color if I am changing the values in braces in below expression
ColorMix2 (
if(rangemin(.5,rangemax((Column(1)/column(2)),-.5)) < 0,
-Sqrt(-(rangemin(.5,rangemax((Column(1)/column(2)),-.5)))/(-.5)),
Sqrt((rangemin(.5,rangemax((Column(1)/column(2)),-.5)))/(.5))),
RGB(255,165,0),RGB(255,255,0), RGB(255,255,0))
Following is the code for the same.
=if(num(
(sum( {stateperfB<Sold_Date = {">=$(sstart)<=$(eend)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {stateperA< Sold_Date = {">=$(sstart)<=$(eend)"}, [Season Code] = {$(MasterCurrentSeason)}>} quantity_returns))
/
sum( {stateperfB<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received)
,'#,##0%')>='60%',Green(),
if(num(
(sum( {stateperfB<Sold_Date = {">=$(sstart)<=$(eend)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {stateperA< Sold_Date = {">=$(sstart)<=$(eend)"}, [Season Code] = {$(MasterCurrentSeason)}>} quantity_returns))
/
sum( {stateperfB<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received)
,
'#,##0%')<'40%',RGB (255,0,0),
if(num(
(sum( {stateperfB<Sold_Date = {">=$(sstart)<=$(eend)"},[Season Code] = {$(MasterCurrentSeason)} >} quantity_sold)- sum( {stateperA< Sold_Date = {">=$(sstart)<=$(eend)"}, [Season Code] = {$(MasterCurrentSeason)}>} quantity_returns))
/
sum( {stateperfB<[Season Code] = {$(MasterCurrentSeason)} >} quantity_received)
,
'#,##0%')='-%',white(),RGB(255,128,0))))