How to make data transform for setting a field value based on multiplication of a number field
Would someone enlighten me on how to create a data transform for multiplying a number field and setting it into a value of an another field?
***Moderator Edit-Vidyaranjan: Updated Platform Capability***
Accepted Solution
SCSK USA Inc
US
Hi Bala,
Thank you for your help. The problem I was facing was that the field property was set as text type so it was not allowing multiplication for a number. After switching to a number property type, I was able to do this.
Thanks,
Masato
Areteans
IN
Hi,
You can use set action in left hand side and equal to in relation and Source should be as below,
(NumberField1 * NumberField2).
Please test and Let me know if it is not meeting your requirement.
Thanks,
Bala
Accepted Solution
SCSK USA Inc
US
Hi Bala,
Thank you for your help. The problem I was facing was that the field property was set as text type so it was not allowing multiplication for a number. After switching to a number property type, I was able to do this.
Thanks,
Masato