topic Using a sum for a colum in a table lookup in Workato Pros Discussion Board

Using a sum for a colum in a table lookup

paolotaverna — Thu, 27 Feb 2025 13:02:31 GMT

Good day, hope all is well,

I am trying to make a sum of a column in a lookup table depending on the id (right now I hard coded the id for testing purpose).

I have tried many formulas but it doe not seem to work. see my pluck image.

Please help 🙂 I would like to avoid looping on the table.

Re: Using a sum for a colum in a table lookup

Prudvi — Thu, 27 Feb 2025 13:28:13 GMT

Hi @paolotaverna,
Can you try using
Entries[datapill].where('Id':Id[datapill]).pluck('Duration Hours').sum
It will search for Id in the entries and then pluck the column and do the sum
Regards,
Prudvi

Re: Using a sum for a colum in a table lookup

paolotaverna — Thu, 27 Feb 2025 13:57:12 GMT

Thank you Prudvi,

I now get this , Error calculating input for field 'temo_1': no method '+' for nil.

I have remove the where to simply test without it but get same error. It's driving me nuts 🙂

This is the output of previous task

{
- Entry ID: 20285829294,
- Entry: {
  - id: IEAEQSOOKRPXABKY,
  - title: Faire la demande d'offre de service pour gestion de changement (Formation et accompagnement),
  - cumul 1: 24782.0,
  - start: 2025-01-12T09:00:00,
  - due: 2025-02-08T17:00:00,
  - parent_folder_id: ["IEAEQSOOI5PW77JN"],
  - Progress: 100.0,
  - Duration Hours: 656.0,
  - taskprogress_x_taskduration: 656.0,
  - cumul 2: 656.0
  }
}

Re: Using a sum for a colum in a table lookup

Prudvi — Thu, 27 Feb 2025 14:02:56 GMT

Hi @paolotaverna,
You can use compact formula to remove if there is any nil in the table.
Regards,
Prudvi

Re: Using a sum for a colum in a table lookup

paolotaverna — Thu, 27 Feb 2025 14:14:54 GMT

Again thank you ! I was almost excited!!!

Error calculating input for field 'temo_1': no implicit conversion of String into Integer

I tried adding .to_f but still not working

Previous step : Duration Hours: 656.0,

Re: Using a sum for a colum in a table lookup

Prudvi — Thu, 27 Feb 2025 14:23:24 GMT

Hi @paolotaverna,
what is the data type of the variable temo_1.
If its integer you might have to use to_i
if its float you might have to use to_f
Regards,
Prudvi