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.
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; )
Thanks in advance!