Using SUM function in Table Type Value set

Content

I am trying to perform the SUM function in a Table Type value set, but it is not fetching results. I have tried various ways like using inline query in the ID Column in table type value set, but nothing seems to work. I need to fetch the sum of particular elements the comes as a payroll inbound, in the HCM Extract, so I will be using this table type value set in fast formula to fetch the values.

Can anyone suggest some way, if they have faced any such scenario.