Portal Custom Filter Summary Calculation
I have a Portal that I am custom Filtering using Global Variables. I am creating another portal (using same Filter) and putting the Summary fields in it. This way I am able to calculate the sum total of custom 'filtered' records.
But is there anyway I can use this Summary field in calculation without showing them on the Layout. I ONLY want to show the new calculated field.
Example: Product: A, B, C, D Sales: 100, 200, 250, 300
User enter Sales (Global Variable) >100 --> I use this value to filter the records
Total Product Sales (Summary field): 750 ---> anyway I can use it in calculation
I know I can use extract 750 using GetLayoutObject, but then I cannot perform calculation and also I have to put the object in the layout (that I do not want to do)