topic Re: Expression in Water Cooler https://community.qlik.com/t5/Water-Cooler/Re-Expression/m-p/351236#M854 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am explaining with example, Please go through the attached jpeg file.</P><P></P><P>On the top <STRONG>Net Collectable as per milestone</STRONG> - 1887.8, <STRONG>Reason Code Amount</STRONG> - 1509.064 and <STRONG>Net Collecable after reason</STRONG> - 447.7841</P><P></P><P><STRONG>Net Collectable as per milestone = Reason Code Amount + Net Collecable after reason</STRONG></P><P></P><P><STRONG>Reason Code Amount = Land + LD Claim Amount + NOC + Projects + Early RR + Others + Invoice + PE</STRONG></P><P></P><P><STRONG>Net Collecable after reason = RM + Fin Closure</STRONG></P><P></P><P>All these amount are coming on the behalf of some reason and at a time there is 2 reason amount will be availale<STRONG> (e.g - either LAND + Project or NOC + PE etc...) </STRONG>which is equal to the<STRONG> NET Collectable as per milestone.</STRONG></P><P></P><P>Suppose the sum of these to reason amount is greater than <STRONG>NET Collectable as per milestone, </STRONG>Than we have to find which reason have<STRONG> max value </STRONG>and then<STRONG> assign to them whatever NET Collectable as per milestone </STRONG>amount is available<STRONG>.</STRONG></P><P></P><P>Please try to resolve. Please revert to me for any clarification.</P><P></P><P><STRONG>Thanks in advance.</STRONG></P></BODY></HTML> Tue, 15 May 2012 05:59:27 GMT sona_sa 2012-05-15T05:59:27Z Re: Expression https://community.qlik.com/t5/Water-Cooler/Re-Expression/m-p/351236#M854 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am explaining with example, Please go through the attached jpeg file.</P><P></P><P>On the top <STRONG>Net Collectable as per milestone</STRONG> - 1887.8, <STRONG>Reason Code Amount</STRONG> - 1509.064 and <STRONG>Net Collecable after reason</STRONG> - 447.7841</P><P></P><P><STRONG>Net Collectable as per milestone = Reason Code Amount + Net Collecable after reason</STRONG></P><P></P><P><STRONG>Reason Code Amount = Land + LD Claim Amount + NOC + Projects + Early RR + Others + Invoice + PE</STRONG></P><P></P><P><STRONG>Net Collecable after reason = RM + Fin Closure</STRONG></P><P></P><P>All these amount are coming on the behalf of some reason and at a time there is 2 reason amount will be availale<STRONG> (e.g - either LAND + Project or NOC + PE etc...) </STRONG>which is equal to the<STRONG> NET Collectable as per milestone.</STRONG></P><P></P><P>Suppose the sum of these to reason amount is greater than <STRONG>NET Collectable as per milestone, </STRONG>Than we have to find which reason have<STRONG> max value </STRONG>and then<STRONG> assign to them whatever NET Collectable as per milestone </STRONG>amount is available<STRONG>.</STRONG></P><P></P><P>Please try to resolve. Please revert to me for any clarification.</P><P></P><P><STRONG>Thanks in advance.</STRONG></P></BODY></HTML> Tue, 15 May 2012 05:59:27 GMT https://community.qlik.com/t5/Water-Cooler/Re-Expression/m-p/351236#M854 sona_sa 2012-05-15T05:59:27Z