topic Pro Rata Calculation in QlikView https://community.qlik.com/t5/QlikView/Pro-Rata-Calculation/m-p/185516#M49969 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Can any body help regarding the pro rata calculation?</P><P></P></BODY></HTML> Wed, 08 Sep 2010 06:04:19 GMT 2010-09-08T06:04:19Z Pro Rata Calculation https://community.qlik.com/t5/QlikView/Pro-Rata-Calculation/m-p/185515#M49968 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Greetings!!!</P><P>This is very intresting question for all of us to calculate PRORATA.</P><H3>The question is:</H3><H3><STRONG>Example: For Office 'A' I am planning to hire 40 people by the end of Dec 2010. So I will start my process to recruit people from this month onwards only. Here I need to equally distribute this 40 openings to each month equally. That is Sep 10, Oct 10, Nov 10, Dec 10. If I hire 7 people in this month then, the remaining will be 40-7=33 and these 33 will be equally distributed for next 3 month when I see the report on 1st October and so on. It should be done dynamically.</STRONG></H3><H3>Also attached sample application to resolve the issue with description of requiremnt in that application.</H3><H3>Thanks in advance.</H3><H3>Regards,</H3><H3>Veman</H3></BODY></HTML> Thu, 02 Sep 2010 12:12:22 GMT https://community.qlik.com/t5/QlikView/Pro-Rata-Calculation/m-p/185515#M49968 2010-09-02T12:12:22Z Pro Rata Calculation https://community.qlik.com/t5/QlikView/Pro-Rata-Calculation/m-p/185516#M49969 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Can any body help regarding the pro rata calculation?</P><P></P></BODY></HTML> Wed, 08 Sep 2010 06:04:19 GMT https://community.qlik.com/t5/QlikView/Pro-Rata-Calculation/m-p/185516#M49969 2010-09-08T06:04:19Z