You need to sign in to do that
Don't have an account?
Michael Webb
Formula field to extract and count values in a field
I have a field on a detail (object name called spaces) record called size (this is the size of the apartment). So I have one record that says 4, another that says 2 another that says 1 and so on, usually around 40 or 50. I need to find a way to show on the master record how many 2's and how many 4's etc for each. The final outcome on the master should be something like this. Total 44, Total 2 bedrooms (amount calculated say 4) total 3 bedrooms (amount calc say 5) and so on and so on. I have no idea how to even attack this one, not even sure where to start.
Thank you very much in advance.
Thank you very much in advance.
On the Space object you have Size which is basically number of bedrooms (not to get confused with all the rooms). Can you change your label to Bedrooms? Also I see it as Percent field, not sure why its a percent, it could be a number field type.
On the Property Object you can add fields
One Bedroom - Rollup Summary and see how I created (screenshot)
the same way you create Two Bedroom , Three Bedroom etc. (on filter criteria just change the size equals to 2, 3 etc)
Hope this helps
All Answers
from what I understand
you have detail records Spaces with size of apartment
space 1 - size 4
space 2 - size 2
space 3 - size 2
space 4 - size 1
so for the above on the master
Total 4,
2 bedrooms - 2
1 bedroom - 1
4 bedrooms - 1
is that what you want??
Please mark this post a best solution for your question if it solves your probleml.
Thanks!
Do you have 1 bedroom count?, 2 Bedroom Count, 3 Bedroom count etc?
One bed 5
Two bed 4
Three bed 4
Calcuated from the different amounts in the size field on the various space objects.
Thank you!
On the Space object you have Size which is basically number of bedrooms (not to get confused with all the rooms). Can you change your label to Bedrooms? Also I see it as Percent field, not sure why its a percent, it could be a number field type.
On the Property Object you can add fields
One Bedroom - Rollup Summary and see how I created (screenshot)
the same way you create Two Bedroom , Three Bedroom etc. (on filter criteria just change the size equals to 2, 3 etc)
Hope this helps
To use this example, if the Spaces Object contained both the Space Field and the Size Field. Could I create a "Similar Spaces" field that calculated how many records existed with the same size?