Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using the following expression to return a percentage
=num(Count({<Method={'1'},UtilizationMonthName={'Month0'}>} Distinct Key) /count({<methddesc={'1','2', '3'},UtilizationMonthName={'Month0'} >} distinct Key),'#,##0%')
what I am trying to do is set a visual cue if the percentages are above and below a set percentage, but I am unsure how to go about this. Any help would be great.
Thanks,
Hi,
you need to be looking at the visual cue tab.
You need to add the upper and lower limit. One thing you may need to check is if you need to use the base number, i.e. pre your num() formating.
If it is just a text box, then you can go to colour and use a expression
If(num(Count({<Method={'1'},UtilizationMonthName={'Month0'}>} Distinct Key) /count({<methddesc={'1','2', '3'},UtilizationMonthName={'Month0'} >} distinct Key),'#,##0%') > 80, Green(), Red())
Or replace with RGB() codes.
Mark
Hi,
Like this? if your %value 80 => Give .8
Hi Mark,
I am looking at the cues tab, just posted what I was using for the expression if it was needed. I am using a straight table, not a text object.
Settu,
Thats what I am trying to do, seems that I was not using .75 for 75%. it is working now.