My Oracle Support Banner

Visual Builder: How To Do Aggregation On A Computed Field That Is A Calculated Column In The Child Level (Doc ID 2408157.1)

Last updated on APRIL 09, 2021

Applies to:

Visual Builder Studio - Version 19.4.3 and later
Information in this document applies to any platform.


This knowledge article reflects updated product names. Visual Builder was formerly known as Visual Builder Cloud Service (VBCS). Please see KM <document 2493395.1> for the full list of recently renamed PaaS services.

Need to aggregate the total amount in a shopping cart BO, which has cart Item as its child BO. The Cart Item has a computed field cart Item Amt which is Qty * Unit Price.
The requirement is to aggregate this calculated column in the parent BO. However, the Visual Builder does not show the computed field in the drop down for aggregation selection.

How to achieve this ?

Sample Shopping Cart Scenario





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.