Forum Discussion

DonLarson's avatar
DonLarson
Qrew Commander
2 years ago

Iterable Record Object

I am using a Pipeline to search for records
Get the value of a Formula Numeric Field
Sum and write that value in another record.

The error message I am getting is:

Validation error: Incorrect template "
{{b|sum(attribute='total_event_bom_item_sell_price')}}".
TypeError: 'Record' object is not iterable


I have successfully done this with other Formula Numeric Fields, so I am not sure why it would break for the same calculation somewhere else.

I did open a Support Case but I have got Boston a bit flummoxed.   

Any ideas?


------------------------------
Don Larson
------------------------------
Pipelines

1 Reply

Sort By
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    2 years ago
    Solved with the help of QB Support.

    It was a Pipeline architecture issue.    To sum the data from a Search, you cannot be in a loop under the Search.   The summation has to happen outside of that Search step.

    ------------------------------
    Don Larson
    ------------------------------