AnsweredAssumed Answered

Portal Custom Filter Summary Calculation

Question asked by Sam_1 on Nov 19, 2014
Latest reply on Nov 21, 2014 by philmodjunk

Title

Portal Custom Filter Summary Calculation

Post

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)

Thank you!

Outcomes