need to create variable?

[Anonymous]

Hi All,

I need create variables where i can get the last month and subtract it from the first month where product is "ABC".

So i created one variable like

lastmonth= count({<Month={$(=Max(Month)}>}Patient) and PRODUCT="ABC"

firstmonth=count({<Month={$(=Min(Month)}>}Patient) and PRODUCT="ABC"

final variable=

=num(($(lastmonth)-$(firstmonth))/$(lastmonth),'##0.0%')

please let me know if this is correct as I am getting error?

thanks a lot!

Anuradha

[jyothish8807]

Hi,

Try like this:

lastmonth= count({<Month={'$(=Max({1}Month))'},PRODUCT={'ABC'}>}Patient)

firstmonth=count({<Month={'$(=min({1}Month))'},PRODUCT={'ABC'}>}Patient)

Br,

KC

[Anonymous]

Hi KC,

I tried it but it showing error in expression ')' expected.

Regards,

Anuradha

[jyothish8807]

Can you try this: or share your expression if it dosent work

(

count({<Month={'$(=Max({1}Month))'},PRODUCT={'ABC'}>}Patient)

-

count({<Month={'$(=min({1}Month))'},PRODUCT={'ABC'}>}Patient)

) /

(

count({<Month={'$(=Max({1}Month))'},PRODUCT={'ABC'}>}Patient)

)