Formula field that calculates average values based on same date and same name of agent
Hello, How do we set up a Formula-Numeric field that calculates average of values based on same date and same name of agent? For example, in the image below, I want to capture in the field "Weekly Quality Score" the average of all Daily Quality Score for Effective Date of 09/30/19 per agent. So, for the first 5 rows, the values under "Weekly Quality Score" should be the same 97.22%. #field #Formulasandfunctions ------------------------------ Isabel Gumanid ------------------------------Formula-User field that shows value of another Nonempty user field
#field #Formulaandfunctions Hi. I have a formula user field FINAL USER that should show the User A if "User A" field is nonempty, else it should show User B, but if User B field is empty, it should show User C. If User C is empty, it should finally show User D. If I have this: If ( IsNull ([User A]), [User B],[User A]), then it works. However, I need to be able to have the conditions below in that FINAL USER field. Can you please help with the formula? If( IsNull([User A]), [User B],[User A], IsNull([User B]), [User C],[User B], IsNull([User C]), [User D],[User C] ) ------------------------------ Isabel Gumanid ------------------------------Formula text field to return ID of a user
#field #Formulasandfunctions Hello, We have a record with Agent Name, ID, Supervisor and Manager. The field "ID" returns the ID of Agent Name. What I want to do is add another field called "Supervisor ID" which should return ID of the Supervisor of that specific Agent. I'm thinking of a formula text field with this logic: ToText([ID] of [Supervisor]) What should be the appropriate formula for this? ------------------------------ Isabel Gumanid ------------------------------
