Using Aggregate functions in Table based Valuesets

Content

Hi All,

In some cases while developing extracts, we will have to use some aggregation operations like sum or count or max functions and by default functionality of table based valueset we cannot achieve it. However there are couple of work around methods that you can use to achieve this requirement.

Please refer the below article for the workaround methods. In 8 out of 10 cases you should be able to achieve your requirement using the work around methods.

https://fusionhcmknowledgebase.com/2020/05/using-aggregate-functions-in-table-valueset/

Thanks,
Sricharan