Calculation to average in a cross reference numeric field based on value list category
I have a value list field name as "Category " in Application B.It has three values cost,innovation and service and another field in Application B has "Enter value " Field which is numeric field ,user will enter from 1 to 5 in this field
I make a cross reference From application B for the application A and i need to populate in three calculated fields like Cost ,innovation and Service based on category ,i need to take average
Ex: Application B has category "Cost" in five records and it has five values from 1 to 5 for the field "Enter value"in all five records.
I need calculation based on cross reference category "Cost " , i need to average this "Enter value "five records likewise for other two categories .each category i will capture in three different fields
Create 3 Helpers in Application B, which would take "Enter Value" field value only for specific category.
E.g. Cost Helper, Innovation Helper and Category Helper.
Then you Application A, you can average these helpers per your need.
Hi, i have attached one example ,which is cross reference field from Application B in Application A
in the screenshot "cost" is the category and numeric value 3 and 4 is "enter value" field
here i need to take avg for category cost ,so avg is 3+4=7,7/2=3.5 ,like wise fro all other category innovation,service etc
Yes, and that is what I mean, you need 3 numeric helpers per category in App B. These helpers will not be used by users, but only for calculation.
E.g. Cost Helper in App B would be:
[Category] = "Costs",
Same for Innovation and Services.
And then you can simply AVERAGE whatever helper you need depending on what category you need.