Expressions

[deepakqlikview_123]

Hello expert,

Can you please tell me how below expression will work.

1 dual

(count(distinct EnquiryID)/1000 & ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')', count(distinct EnquiryID)

2  count

(distinct{$<Year= {$(=Max(Year))}>} EnquiryID)
-
count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID)
)
/
count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID)
)

3.

dual

(count(distinct if( EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))/1000 &
' (' & num((count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))/
count(distinct total if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))), '0.00%') & ')',
count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))
)

Thanks,

[deepakqlikview_123]

Hello All,

Can you please help me out in this.

Thanks

[er_mohit · Accepted solution]

Hii in first

1 dual

(count(distinct EnquiryID)/1000 & ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')', count(distinct EnquiryID)

here you Calculate the unique EnquiryID with % utilization of unique EnquiryID using this expression as above ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')' and last one is only used for sorting purpose as alike your EnquiryID because from starting you using dual function

in 2nd case

2  count(distinct{$<Year= {$(=Max(Year))}>} EnquiryID) //for getting the  EnquiryID on based of maximum year
- count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID))/ //or getting the  EnquiryID on based of maximum year -1like  if its 2014 then it                                                                                                                                                                                                                    display 2013
count(distinct{$<Year= {$(=Max(Year)-1)}>} EnquiryID) //or getting the  EnquiryID on based of maximum year -1 and divide it to above two       )                                                                                                                                                                              expression output

3rd case

dual

(count(distinct if( EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))/1000 &
' (' & num((count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))/
count(distinct total if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))), '0.00%') & ')',
count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID))
)

here first getting unique the EnquiryID with condition EnquiryStatusID <> '0' and FinanceTypeID=2 and also % utilization for each EnquiryID as alike 1st case but here it done with using conditions and last expression count(distinct if(EnquiryStatusID <> '0' and FinanceTypeID=2,EnquiryID)) is used to display the above expression with sorting purpose

because of using dual function