Calling a table validated value set from fast formula — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calling a table validated value set from fast formula

edited Oct 14, 2020 8:07AM in Payroll and Global Payroll Interface (GPI) 7 comments

Summary

Calling a table validated value set from fast formula

Content

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:

  1. You are not allowed to use aggregate functions (e.g. SUM) in the SELECT clause
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!