Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Calling a table validated value set from fast formula
Summary
Calling a table validated value set from fast formulaContent
Hi all,
I have a requirement to sum multiple element entry values (from multiple elements) in a fast formula. There is no DBI I can use to achieve this (via a loop in the formula), so I was planning on creating a table-validated value set with a SQL query behind it, and then use the GET_VALUE_SET function in the formula. I’ve been doing some testing on this and have hit the following issues:
- You are not allowed to use aggregate functions (e.g. SUM) in the SELECT clause
Tagged:
0