Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have added below query to make "RED" if plan is more than actual and if actual is more than plan "GREEN"
if(Avg([Plan PSD_FM])> Avg([Actual PSD_FM]),RGB(255,99,71),RGB(50,205,50))
but in 0 its shows "GREEN" I want to make it "WHITE" in 0. please find the image in the attachment
Correct Answer
If(Avg([Plan GRN Hit Rate_STORES])>Avg([Actual GRN Hit Rate_STORES]), RGB(255,99,71),
If(Avg([Plan GRN Hit Rate_STORES])<=Avg([Actual GRN Hit Rate_STORES]), RGB(50,205,50), White()))
Try something like this...
Properties-->Visual Queues
Enter the max/min values, based on the requirement
I can't do so because is a comparison and plan and actual values get changes time to time
so I can't set a exact value
Olá, Tenta isso
if(Avg([Plan PSD_FM])> Avg([Actual PSD_FM]),RGB(255,99,71),if(Avg([Plan PSD_FM])< Avg([Actual PSD_FM]),RGB(50,205,50),White()))
Abs.
You should put this calculation in every expression on the background color by clicking on the plus side of the expression.
Background Color Expression:
if(Avg([Plan PSD_FM]) > Avg([Actual PSD_FM]),RGB(255,99,71),if(Avg([Plan PSD_FM]) = 0 or IsNull(Avg([Plan PSD_FM])) , RGB(255,255,255), RGB(50,205,50)))
Best Regards.
Tonial.
Try:
if(Avg([Plan PSD_FM]) > Avg([Actual PSD_FM]),RGB(255,99,71),if([Plan PSD_FM] = 0, RGB(255,255,255), RGB(50,205,50)))
Correct Answer
If(Avg([Plan GRN Hit Rate_STORES])>Avg([Actual GRN Hit Rate_STORES]), RGB(255,99,71),
If(Avg([Plan GRN Hit Rate_STORES])<=Avg([Actual GRN Hit Rate_STORES]), RGB(50,205,50), White()))