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!

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (0)

Report

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);

}

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report

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!

Was this reply helpful? Yes No