How can I get the sum to show in the Jotform Tables?

  • tresorieredentellieresdupoitou
    Demandé le 29 mars 2024 à 12:33

    Bonjour,


    Je voudrai faire le total d'une colonne mais jotform ne m'offre pas cette possibilité dans le popup.

    SUM n'apparait pas .(voir capture d'écran)

    Pourquoi ?

    Bonne journée . Merci pour votre réponse.

  • Neil Jotform Support
    Répondu le 29 mars 2024 à 12:56

    Hi tresorieredentellieresdupoitou,

    Thanks for reaching out to Jotform Support. Unfortunately, our French Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in French, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. Unfortunately, the aggregations are not available on the Form Calculation widget. It is only available on the following column types: Number, Spinner, Star Rating, and Advanced Formula. You can add a new column, and add the "Montant du chèque de frais de repas (en euros)" field to be able to get the sum. Let me show you how:

    1. In Jotform Tables, click on the Add button to add a column.

      How can I get the sum to show in the Jotform Tables? Image 1 Screenshot 50
    2. Then, go to Formula at the top, choose Advanced Formula, and click on Next.

      How can I get the sum to show in the Jotform Tables? Image 2 Screenshot 61
    3. Enter your column name, and click on Next.
    4. Now, add the Montant du chèque de frais de repas (en euros) field.
    5. Once you're done, click on Create Column.

      How can I get the sum to show in the Jotform Tables? Image 3 Screenshot 72

    That's it. When you click on Add Summary, you will now be able to get the Sum. Check out my screencast below:

    How can I get the sum to show in the Jotform Tables? Image 4 Screenshot 83

    Give it a try and let us know if you need more help.

  • tresorieredentellieresdupoitou
    Répondu le 29 mars 2024 à 14:52

    Thank you very much.

    I am very happy

    I got it. It works very well.

    good week-end