I require an inverted %

[helen_pip]

Hello

I have a % calculation which returns the value of 12.91%

num

((Count({<YEAR = {$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER)/Count({<YEAR = {$(=Max(YEAR)-1)

However what I want to achieve is 100% - 12.91% so I get the value of 87.09%

Can anyone tell me how I can achieve this?

Thanks

Helen

[CELAMBARASAN]

use

1 - num([Your Expression])

[helen_pip]

Hello

Thank you for your response

I get a null value - when I tried this:

Have I written it correctly?

1-

num((Count({<YEAR = {$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER)/Count({<YEAR = {$(=Max(YEAR)-1)

Thanks

Helen

[CELAMBARASAN · Accepted solution]

I hope this might be your need.

1-

num((Count({<YEAR = {$(=Max(YEAR))}>}LOCAL_PATIENT_IDENTIFIER)/Count({<YEAR = {$(=Max(YEAR)-1)}>}LOCAL_PATIENT_IDENTIFIER)

[helen_pip]

Thank you

This works for me

Helen