SUMPRODUCT in a calculated field

 
1
0
-1

How can we have SUMPRODUCT in a calculated field?

Column A and Colum B Each row value be multiplied and added up in a single field ?

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi - if you are using professional or enterprise you can leverage the Calculation Field already baked into joget. community users would leverage a custom html with javascript to perform calculation such as the example below.


      <script>
    function calculateTotal(amount) {
        var disc = FormUtil.getField("disc").val();
        if (disc === undefined || disc === "") {
            disc = "0"; //set a default
        }
        return amount * (100 - parseFloat(disc)) / 100;
    }
</script>

      see: calculation tip in spreadsheet (subform)

      Good Luck

      tony


        CommentAdd your comment...