Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
Hello All,
Can you please help me out in this.
Thanks
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