Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone, I am currently trying to add color to one of the rows in my pivot table and everything works except when trying to convert some of the values that sit in as 'TBD' as black, instead they still come in as green. How do I layout my expression that actual percentages still come through as a color and all 'TBD's come in as black? My current expression is below.
=if(percent > 0 ,green(),
if(percent <= -.05, rgb(255,0,0),
if(percent >-.05 and percent <= 0,rgb(255,205,3),
if(percent = 'TBD',black()))))
Thanks!
=if(Percent = 'TBD',black(),if(percent > 0 ,green(),
if(percent <= -.05, rgb(255,0,0),
if(percent >-.05 and percent <= 0,rgb(255,205,3),
))))
=if(Percent = 'TBD',black(),if(percent > 0 ,green(),
if(percent <= -.05, rgb(255,0,0),
if(percent >-.05 and percent <= 0,rgb(255,205,3),
))))