suryasabniveesu
Member
The attached file is having live data of BG Commission. BG Commission rate, BG amount is given.
If the status of BG is "Issue" then BG Commission to be calculated for those number of days i.e. from BG date to till date of Extension (AD column in attached file).
If the status of BG is"Extension" then BG Commission to be calculated for the number days between Original Validity Date and Extended Validity Date (AD - AC columns)
Now the requirement is if the status of BG is "Extension" then BG commission to be found financial year wise.
For example, against BG No:2657BG1432009 of attached file, Original BG date is 10-Jun-09 (FY 2009-10) and Original Validity date is 30-Apr-13 (FY 2013-14). This BG is extended till 31-Jan-17 (FY 2016-17).
Output (preferably in Pivot) shall be year wise. BG commission from May-14 to 31-Jan-17 shall be calculated FY year wise.
2013-14 2014-15 2015-16 2016-17
335days 365days 365days 306 days (till 31-Jan-17)
If the status of BG is "Issue" then BG Commission to be calculated for those number of days i.e. from BG date to till date of Extension (AD column in attached file).
If the status of BG is"Extension" then BG Commission to be calculated for the number days between Original Validity Date and Extended Validity Date (AD - AC columns)
Now the requirement is if the status of BG is "Extension" then BG commission to be found financial year wise.
For example, against BG No:2657BG1432009 of attached file, Original BG date is 10-Jun-09 (FY 2009-10) and Original Validity date is 30-Apr-13 (FY 2013-14). This BG is extended till 31-Jan-17 (FY 2016-17).
Output (preferably in Pivot) shall be year wise. BG commission from May-14 to 31-Jan-17 shall be calculated FY year wise.
2013-14 2014-15 2015-16 2016-17
335days 365days 365days 306 days (till 31-Jan-17)