Multiplying two fields by each other and displaying this res

Posted by Ramon Schouten on 27-Jul-2016 10:55

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

Rollbase - Forum

Posted by Vimalkumar Selvaraj on 27-Jul-2016 11:20

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.

[View:http://documentation.progress.com/output/rb/doc/#page/rb%2Fformulas.html%23:550:50]

Created sample App for your reference.

[View:/cfs-file/__key/communityserver-discussions-components-files/25/Total-Value_5F00_v2.xml:320:240]

Please let me know if you need more details.

Thanks,

Vimal.

All Replies