Expression

[deepakqlikview_123]

Hello Team,

Can you please tell me how below expression works,

='Locationwise Enquiry Analysis ( In K)' &

chr(10)&chr(13) &

GetcurrentSelections('-')&'='& Count (distinct EnquiryID)/1000

Thanks in advance.

[MK_QSL]

='Locationwise Enquiry Analysis ( In K)' &                              ==> This will type as it is

chr(10)&chr(13) &                                                                      ==> NEW LINE

GetcurrentSelections('-')&                                                         ==> Give you your current selection

'='                                                                                                 ==> give you =

& Count (distinct EnquiryID)/1000                                           ==> Your DISTINCT EnquiryID Count will be divided  by 1000

SO your result would be something like below

Locationwise Enquiry Analysis ( In K)

Customer Name: ABCD =0.001

Considering that your have selected Customer ABCD from Customer Name Field... Hope this helps...

[CELAMBARASAN]

Hi,

& is concatenate two strings

Chr(10) is Line Feed

Chr(13) is Carriage return

GetcurrentSelections will give you the selected values with field names.

Count (distinct EnquiryID)/1000 will give you the number of enquiries in (K).

[Luis_Cortizo]

It writes the text: 'Locationwise Enquiry Analysis ( In K)', and then in a new line (that's the reason to concatenate chr(10) and chr(13) t shows the current selections of the document separated by the '-' sign before and equal sign and after that the distinct number of values of the fields EnquiryID divided by 1000

So, let's say that you have selected 2014, January and the distinct number of values on the field EnquiryID is 150000; your expression would return:

Locationwise Enquiry Analysis ( In K)

Year: 2014 - Month: Jan = 150

Hope it helps.

Best regards.

[#5]

it will show the text 'Locationwise Enquiry Analysis ( In K)', the current field that you have selected(fieldname and the data) and it will do the calculation at the end, something like this:

Locationwise Enquiry Analysis ( In K)  Fieldname: datainfield = Count (distinct EnquiryID)/1000