Microsoft Dynamics 365 | Integration, Dataverse...

Multiply a currency field with whole number

(0) Share

Report

Posted on by Prajwal Bhetwal

I have a requirement of multiplying the price field which is a currency data type with the unit which is a whole number data type and store it in another field total amount which is a currency field.

Tried to use the calculated field but it doesn't support the currency. Can someone help me write a JS to achieve this?

Many thanks!

All responses (3)

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report

RE: Multiply a currency field with whole number

Hi Partner,

Have any updates?

Please feel free to contacts me if you have any questions!

Could you click 'Yes' under title to close the thread if my answer is helpful!

Thanks in Advance!
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

RE: Multiply a currency field with whole number

Hi Prajwal,

Based on the Microsoft documentation, the calculation field supports currency type.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields#column-types-that-support-calculations

And i can create the calculated field to get total amount:

Test:
Suggested answer

Pradeep Rai 5,487 Super User 2025 Season 1 on at

Like (0)

Report

RE: Multiply a currency field with whole number

function calculateamount(executioncontext)

{
var formContext=executioncontext.getFormContext();

var amount = formContext.getAttribute(‘logical name’).getValue();

var unitvalue=formContext.getAttribute(‘logical name’).getValue();

var total=amount*unitvalue;

formContext.getAttribute(‘logical name’).setvalue(total);

}