The Calculated field if used to calculated the difference between 2 fields gives the difference in amount. Is there a way to get the difference in count. The count formula in Calculated field doesn't seem to work. Kindly help
Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
// all fields are numeric type
REPLACE field_a WITH 25, field_b WITH 4, field_sum WITH field_a + field_b, field_prod WITH
field_a * field_b
REPLACE field_a WITH 60, field_b WITH 5, field_sum WITH field_a + field_b, field_prod WITH
field_a * field_b
field_a field_b field_sum field_prod
25 4 29 100
60 5 65 300
Don't use keywords as field names (ex. SUM).
My suggestion is to use a Pivot Table. Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.
Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet. then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet. Next drop another instance of the STATUS field into the "drop row fields here" column. And lastly drop the OWNER field into the "drop column fields here" section. You should now be viewing a report showing you exactly what you were looking for.
Recurring deposit interest is calculation may vary depends on compounding period. You have to invest an amount every month interest will be calculated for the current holding in your recurring deposit account. And every compounding period interest amount will be added into holdings or available balance. You can calculate the Recurring deposit using this recurring deposit calculator
You need to create subtotals so that it looks like something like this:
Prod/units Amt. Level Total
xxxx 10.00 1 yyyy 20.00 1 30.00
dddd 40.00 2 ffff 30.00 2 70.00
To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.
If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.
Some reading: http://www.ehow.com/how_13020_pivot-table-wizard.html http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx http://www.ozgrid.com/Excel/excel-pivot-tables.htm
Also Google "Excel pivot table wizard" to get more.