Hi guys,
I need your help for calculating three formulas. Attachment contains qvw file, data which goes to qw, and logic discription in xls. QV contains table PaymentFee table that is combined by two of Payment and Fee with appropriate flag.
I have provided example for period 2012-06. What I should use for calculation? Thank you very much for any help for me.
I formula descr.:
1) Should get all cases(4,3,2,1) from payment table and figure out sum of amount starting from 2012-06 till 2012-01 period.
2) For identified cases from 1.point, we need figure out sum of amount in fee table from 2012-06 till 2012-01 period.
3) For identified cases from 1.point, we need figure out sum of value in Total table.
II formula descr.:
1) Should get all cases(4,2,1) from payment table for last three periods (2012-06, 2012-05, 2012-04) and figure out sum of amount for these cases starting from 2012-06 till 2012-01 period.
2) For identified cases from 1.point, we need figure out sum of amount for these cases in fee table from 2012-06 till 2012-01 period.
3) For identified cases from 1.point, we need figure out sum of value in Total table.
III formula descr.:
1) Should get all cases (4,2) from payment table for current period (2012-06) and figure out sum of amount for these cases starting from 2012-06 till 2012-01 period.
2) For identified cases from 1.point, we need figure out sum of amount for these cases in fee table from 2012-06 till 2012-01 period.
3) For identified cases from 1.point, we need figure out sum of value in Total table.