Multiplying two fields by each other and displaying this result in another. - Forum - Rollbase - Progress Community

Multiplying two fields by each other and displaying this result in another.

 Forum

Multiplying two fields by each other and displaying this result in another.

This question is answered

Hi,

I wish to make a field.Which multiplies the totals of two other fields.

The fields to multiply by each other are 'Uurtarief' and 'Maximum Hours'.
The result of this should be shown in the 'Totaal Tarief' field.

The syntax for coming up with the 'Uurtarief is as followed:

The field integration names and more are shown here:

What i tried was very basic and was something like this:

Can anyone help me with this or point me in the right direction?

I would most appreciate it, i can't find syntax or formula for multiplying fields and showing the result in one field.

Greetings,

Ramon Schouten

QAP P3 Solutions

Verified Answer
  • Hi Ramon,

    In order to get multiplication of two field value please create a formula field and select preferred return type , then just write simple javascript code to return your result by multiplying both fields.

    Say in your case

    return ({!TariefTest2} * {!Maximum_hours});

    Please refer this documentation to know more details about formula fields.

    Created sample App for your reference.

    Total Value_v2.xml

    Please let me know if you need more details.

    Thanks,

    Vimal.

All Replies
  • Hi Ramon,

    In order to get multiplication of two field value please create a formula field and select preferred return type , then just write simple javascript code to return your result by multiplying both fields.

    Say in your case

    return ({!TariefTest2} * {!Maximum_hours});

    Please refer this documentation to know more details about formula fields.

    Created sample App for your reference.

    Total Value_v2.xml

    Please let me know if you need more details.

    Thanks,

    Vimal.