AnsweredAssumed Answered

Using a Case number range formula to display image

Question asked by wildwood28 on Jun 4, 2018
Latest reply on Jun 9, 2018 by bigtom

I am wanting to display in image in a container based on a Case formula. I have managed to get the first two tiers working but then just shows the same image for the rest.

 

For example:

 

Less than 0 - show Sad image

from 1 to 19 - show Smile image

from 20 to 39 - show BigSmile image

from 40 to 59 - show Laugh image

60+ - show Angel image

 

This is what I have come up with...works for the first one (<0), and then just shows the Smile Face image for the rest...

 

Case (Co % Var < 0; Faces::Sad ; Co % Var < 19; Faces::Smile ; Co % Var < 39; Faces::BigSmile ; Co % Var > 40 ; Faces::Laugh ; Co % Var > 60; Faces::Angel;  )

 

Help!

 

Thanks in advance!

Outcomes