You need to sign in to do that
Don't have an account?
srikanth challa
How to calculate total count of the field with a particular status in formula field
Can we calculate total number of records with Warranty Status = 'INACTIVE' in the formula field. If NO could you guys please suggest me a best way to do it?
however, I think you can create a workflow to update the field of an object when a new record is saved or modifed to be Warranty Status Incavtive
Another good choice is to do an apex trigger and calculate the field value every time a change is made to the record, however you need to have a parent object,
If you dont have a parent object... the RollUp summary field would be your best choice. Create a Parent object and create a master detail relationship from the record you have (the one with the Warranry Status field) to the new custom object and in the parent create a rll up summary with the criteria Vidya said on the previous answer
All Answers
however, I think you can create a workflow to update the field of an object when a new record is saved or modifed to be Warranty Status Incavtive
Another good choice is to do an apex trigger and calculate the field value every time a change is made to the record, however you need to have a parent object,
If you dont have a parent object... the RollUp summary field would be your best choice. Create a Parent object and create a master detail relationship from the record you have (the one with the Warranry Status field) to the new custom object and in the parent create a rll up summary with the criteria Vidya said on the previous answer