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
    ------------------------------
MikeTamoush's avatar
MikeTamoush
Qrew Elite
3 years ago

I mistyped in my post. I should have said I tried {{MyField * .68}} and it would not work. 

However, {{MyField * 0.68}} DOES work! Thank you! Turns out that leading zero is important.



------------------------------
Mike Tamoush
------------------------------
MikeTamoush's avatar
MikeTamoush
Qrew Elite
3 years ago

Any idea the syntax to round the number to 2 decimals?

I tried {{MyField * 0.68 | round(2) }} but this did not work. 

------------------------------
Mike Tamoush
------------------------------

  • DougHenning1's avatar
    DougHenning1
    Community Manager
    3 years ago

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



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

      You're gonna laugh... well, or cry, depending on how long you've worked on this. go to the outcome fields properties. 

      Change this to 2 for 2 decimal places:



      ------------------------------
      Shane Miller
      ------------------------------
      • ShaneMiller1's avatar
        ShaneMiller1
        Qrew Cadet
        3 years ago

        If you wanted to get fancy and do it in JINJA2 pipelines then plug this in:

        {{ (MyField * 0.68)|round(2) }}


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