Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Elite
3 years ago
Solved

Performing Multiplication in Jinja for Pipelines

I am trying to set a field to [MyField] * .68 I tried this: {{a.MyField  .68}} but that syntax wont even save. I also tried {{My.Field}}*.68. This saves, but produces an error when the pipeline...
  • DougHenning1's avatar
    DougHenning1
    3 years ago

    Round to 2 decimals: {{ "%.02f" | format(MyField * 0.68) }}



    ------------------------------
    Doug Henning
    ------------------------------
ShaneMiller1's avatar
ShaneMiller1
Qrew Cadet
3 years ago

Just to elaborate, you would drag your [MyField] field from the pre-populated list on the right side into the field that you want the calculation to occur in. This will automatically format the field name for you by putting the appropriate step number a. or b. etc along with the {{ }} in the correct position



------------------------------
Shane Miller
------------------------------