Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a set analysis expression that I need to display as a percentage, can anyone help?
Expression: = (count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity]))
This expression is used as 'Text in chart' on a gauge chart FYI.
Thank you
How about this
Num(Count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>} [Delivered Quantity])/Count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late'}>} [Delivered Quantity]), '#0.0%')
May be like this
Num( count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity]), '#,##0%')
Did not work unfortunately
Try Like this:
num(
(count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity]))
/
(count({1<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}total [Delivered Quantity])),'##.0%')
Hi Jyothish,
Thank you the expression has been accepted as suitable however the percetnage value shown is different to the one shown from the original expression shown in my first post.
Any ideas?
Hi Alexander,
Try this,
=Num(((count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/
(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity]))),'##0.00%')
hopefully this will work.
How about this
Num(Count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>} [Delivered Quantity])/Count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late'}>} [Delivered Quantity]), '#0.0%')
Thank you Sunny and everyone else this has worked
Cheers,
Alex.
Missed the formatting
Thanks buddy
It was my mistake, i did not say the "/" in your expression and thought this as a complete one count. So i divided the same expression with the total
Br,
KC