Forum Discussion
EverettPatterso
6 years agoQrew Captain
Is this what you are wanting to accomplish? In the summary field options, you can change the dropdown "Choose a field from the "Projections" table" and select the Revenue field you want. You can make additional summary fields for minimum and maximum then change the dropdowns to the appropriate revenue.
------------------------------
Everett Patterson
------------------------------
------------------------------
Everett Patterson
------------------------------
AshleyAsante
6 years agoQrew Cadet
Thanks for your help so far,
I got the first part of the solution.
I created Min Rec ID and Max Rec ID summary fields.
But I'm not sure how you were able to then able to create (Min Rec ID Shipped Revenue, Max Rec ID Shipped Revenue, etc).
Could you send me a screenshot of the field properties for one of those?
------------------------------
Ashley Asante
------------------------------
I got the first part of the solution.
I created Min Rec ID and Max Rec ID summary fields.
But I'm not sure how you were able to then able to create (Min Rec ID Shipped Revenue, Max Rec ID Shipped Revenue, etc).
Could you send me a screenshot of the field properties for one of those?
------------------------------
Ashley Asante
------------------------------
- EverettPatterso6 years agoQrew CaptainJust change the Field to summarize from Related Parent to Warehouse Revenue and leave the function on Minimum
------------------------------
Everett Patterson
------------------------------