Expression

[deepakqlikview_123]

Hello All,

Can you please tell me how below exp will work

in title of chart

=GetCurrentSelections('-')&'='&count(distinct if((EnquiryStatusID = '3' or EnquiryStatusID = '4'),EnquiryID))/1000

thanks

[MK_QSL]

This will give you result of COUNT of EnquiryID in thousands where EnquiryStatusID is either 3 or 4.

Get Current Selections will give you selected Field Name...

[sushil353]

Hi,

It will  Returns a string with the current selections in the document separated by '-' also concatenated with a count of EnquiryID where EnquiryStatusID is either 3 or 4

HTH

Sushil

[its_anandrjs]

The below will gives what you select current in list box

=GetCurrentSelections('-')

and below script counts DISTINT UNIQUE EnquiryID where it is equals to EnquiryStatusID = '3' or EnquiryStatusID = '4' and divides to 1000 and get values and concat with =GetCurrentSelections('-') with &'='& and shows value like Value = depends on the EnquiryID value

count(distinct if((EnquiryStatusID = '3' or EnquiryStatusID = '4'),EnquiryID))/1000 

Hope this helps