Expression help

[satishkurra]

Hi

The below expression is showing OK. But i'm not able to see a color change for GetSelectedCount(Family) >=1 and Family='Nursing'.

Not sure what is going wrong here.

Can some one help me on the same....

Expression:

=if(GetSelectedCount(Family)<1,

  if(Sum(Sales)=0,'autocolor,#d3d3d3',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

  if(Sum(Sales) > 300, 'autocolor,#00008B')))))

  ,if(GetSelectedCount(Family)>=1,

  if(Sum(Sales)=0,'autocolor,#00FFFFFF',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

  if(Sum(Sales) > 300, 'autocolor,#00008B')))))

  ,if(GetSelectedCount(Family)>=1 and Family='Nursing',

  if(Sum(Sales)=0,'autocolor,#00FFFFFF',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#ff7f7f',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#ff6666',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#ff4c4c',

  if(Sum(Sales) > 300, 'autocolor,#ff3232'))))))))

[sunny_talwar · Accepted solution]

May be this:

=if(GetSelectedCount(Family)<1,

  if(Sum(Sales)=0,'autocolor,#d3d3d3',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

  if(Sum(Sales) > 300, 'autocolor,#00008B')))))

,if(GetSelectedCount(Family)=1 and Family='Nursing',

  if(Sum(Sales)=0,'autocolor,#00FFFFFF',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#ff7f7f',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#ff6666',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#ff4c4c',

  if(Sum(Sales) > 300, 'autocolor,#ff3232'))))))

,if(GetSelectedCount(Family)>=1,

  if(Sum(Sales)=0,'autocolor,#00FFFFFF',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

  if(Sum(Sales) > 300, 'autocolor,#00008B')))))))

or

=if(GetSelectedCount(Family)<1,

  if(Sum(Sales)=0,'autocolor,#d3d3d3',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

  if(Sum(Sales) > 300, 'autocolor,#00008B')))))

,if(GetSelectedCount(Family)>=1 and SubStringCount(Concat(DISTINCT Family, '|'), 'Nursing') = 1,

  if(Sum(Sales)=0,'autocolor,#00FFFFFF',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#ff7f7f',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#ff6666',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#ff4c4c',

  if(Sum(Sales) > 300, 'autocolor,#ff3232'))))))

,if(GetSelectedCount(Family)>=1,

  if(Sum(Sales)=0,'autocolor,#00FFFFFF',

  if(Sum(Sales) >=1 and Sum(Sales) <= 100, 'autocolor,#87CEEB',

  if(Sum(Sales) >= 101 and Sum(Sales) <= 200, 'autocolor,#1E90FF',

  if(Sum(Sales) >=201 and Sum(Sales) <= 300, 'autocolor,#0000FF',

  if(Sum(Sales) > 300, 'autocolor,#00008B')))))))

[satishkurra]

First one worked and i didn't try the 2nd one

[sunny_talwar]

Awesome, thanks for providing the information on which one worked