Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is the meaning of the below expression?
Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID), 0)
HI,
I think you missed some part of the expression in the beginning, I guess it would be either If() or Alt(). The above expression counts the Distinct HSP_ACCOUNT_ID which is having ON/OFF Pathway as {'OFF'}.
Hope this helps you.
Regards,
Jagan.
I think you have a additional (,0)) thing at the end which may be part if statement. But this part (Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID)) means that you are distinctly counting HSP_ACCOUNT_ID where [ON/OFF Pathway] is OFF
HTH
Best,
Sunny
Hi sunindia
Thank you for your reply. Yes, I confused with ,0.
Ya I think this expression by itself with ,0) at the end will give you an error.
assuming you have expression
alt(Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID), 0)
First - You are counting the distinct values of HSP_ACCOUNT_ID associated with [ON/OFF Pathway] where value is 'OFF'.
If there is no values of HSP_ACCOUNT_ID associated with [ON/OFF Pathway] alt function returns zero
HI,
I think you missed some part of the expression in the beginning, I guess it would be either If() or Alt(). The above expression counts the Distinct HSP_ACCOUNT_ID which is having ON/OFF Pathway as {'OFF'}.
Hope this helps you.
Regards,
Jagan.
Hi jagan,Kush141087,
Actual expression was this. It was my mistake not seen keen.
Thank you for your answers.
=If(Getpossiblecount([ON/OFF Pathway])>1 OR [ON/OFF Pathway]='OFF', Count({<[ON/OFF Pathway]={'OFF'} >} Distinct HSP_ACCOUNT_ID), 0)