gopalakrishnarao1
Board Regular
- Joined
- Nov 23, 2008
- Messages
- 146
I am having the data of 214 branches. Now I want to calculate the depreciation for the items. The items are categorised, and for each category depreciation rate varies. Every branch has been given a branch code. Is there any formula to put the in single command putting the rate for eg. if type 20% for one category, it should be updated in all thebranches, and if type 33.33% for one category in one branch it should be updated in all the 214 branches. Advance sincere thanks to the solution provider.
Group NameValueCurr.Val. STEEL FURNITURE219696.41 124253.00 WOODEN FURNITURE153815.54 62581.98 ELECTRICAL INSTALLATIONS1115.00 601.00 BICYCLE2000.00 973.00 ELECTRONIC ITEMS1267138.00 1123255.00 TOTAL1643764.95 1311663.98 ranch : Bilikere (2) Group NameValueCurr.Val. STEEL FURNITURE46912.87 18328.00 WOODEN FURNITURE65732.50 20023.00 ELECTRICAL INSTALLATIONS1686.00 996.00 BICYCLE650.00 6.00 ELECTRONIC ITEMS10950.00 6366.00 TOTAL125931.37 45719.00
Group NameValueCurr.Val. STEEL FURNITURE219696.41 124253.00 WOODEN FURNITURE153815.54 62581.98 ELECTRICAL INSTALLATIONS1115.00 601.00 BICYCLE2000.00 973.00 ELECTRONIC ITEMS1267138.00 1123255.00 TOTAL1643764.95 1311663.98 ranch : Bilikere (2) Group NameValueCurr.Val. STEEL FURNITURE46912.87 18328.00 WOODEN FURNITURE65732.50 20023.00 ELECTRICAL INSTALLATIONS1686.00 996.00 BICYCLE650.00 6.00 ELECTRONIC ITEMS10950.00 6366.00 TOTAL125931.37 45719.00
Last edited: