Closed
Solved
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
Posted: 7 years ago
SCSK USA Inc
SCSK USA Inc
US
Posted: 7 years ago
Areteans
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
Posted: 7 years ago
SCSK USA Inc
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
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