Hi could anyone please help me again.
I was trying...
# generalk
KingDaGreat
10/06/2021, 7:54 AMHi could anyone please help me again.
I was trying to multiply the following and it does show error.
I already tried to add ?numbers at the end of each values/variables but couldn't get it right
I already used is_number and both variable shows Yes'
m
Michael McNamara
10/06/2021, 4:14 PMCurious as to why you are using freemarker for this. Have you simply tried ${transaction.custbody42} * ${transaction.total} ?. Also, I have had difficulties at times using a percent field in multiplication. Netsuite will sometimes read that as a string.
k
KingDaGreat
10/07/2021, 12:14 AMHi Michael,
The reason why I used the freemarker is if I use that ${transaction.custbody42} * ${transaction.total} on the <p> tag, it does print the values of each field and won't be multiplied
m
Michael McNamara
10/07/2021, 12:17 AMAhhh. You would need to string together the <p> tags and the calculation
k
KingDaGreat
10/07/2021, 12:18 AMwhat do you mean 🙂
KingDaGreat
10/07/2021, 12:24 AMMy screenshot was the result of ${transaction.custbody42} * ${transaction.total}. That's why I was trying to do the calculations first on the freemarker then use the result on p tag of the email template.
m
Michael McNamara
10/07/2021, 12:34 AMOK. So when I do this:
<td align=“right” colspan=“4">${item.rate +100}</td>
I get the amount increased by 100. You should try:
${transaction.custbody42 * ${transaction.total}}
k
KingDaGreat
10/07/2021, 12:35 AMAhh I see, will try that for a sec.
KingDaGreat
10/07/2021, 12:38 AMmessage has been deleted
KingDaGreat
10/07/2021, 12:40 AM${transaction.custbody42Â *Â transaction.total}
I tried this instead it seems to work but same error I think when I try it on freemarker
KingDaGreat
10/07/2021, 12:40 AMmessage has been deleted
KingDaGreat
10/07/2021, 12:41 AMI'll try to convert to number again to see how it goes
KingDaGreat
10/07/2021, 12:42 AMOhh wait one sec, I think it's referring on the other line, I must have remove the old calculation on freemarker
m
Michael McNamara
10/07/2021, 12:44 AMThis is a ricky one.
k
KingDaGreat
10/07/2021, 12:44 AM${transaction.custbody42?number * transaction.total?number}
KingDaGreat
10/07/2021, 12:45 AMI'll try to find a solution with that percent type of field
m
Michael McNamara
10/07/2021, 1:03 AMI can confirm this works as a calculation <p>${item.rate * item.rate}</p>
Michael McNamara
10/07/2021, 1:08 AMSo as I mentioned in the beginning, i think your percent value is being evaluated as a string and the two variables can’t be multiplied.
k
KingDaGreat
10/07/2021, 1:08 AMYup yup, do you have solution for that?
KingDaGreat
10/07/2021, 1:09 AMI wasn't sure how to convert that to make the calculation work
m
Michael McNamara
10/07/2021, 1:09 AMNot unless you change your custom body field to a decimal
k
KingDaGreat
10/07/2021, 1:09 AMI wasn't sure for that as they intend to display the percent sign, just like this 20%
KingDaGreat
10/07/2021, 1:10 AMtransaction.custbody42?replace("%", "", "r")?number
KingDaGreat
10/07/2021, 1:10 AMI tried this but the error show about "" which can't be converted to string
KingDaGreat
10/07/2021, 1:10 AMnumber i meant
m
Michael McNamara
10/07/2021, 1:12 AMNot sure from here.
k
KingDaGreat
10/07/2021, 1:14 AMI'll just try to raise this on NS team
m
Michael McNamara
10/07/2021, 2:33 AMJust saw something regarding conversion using TO_NUMBER(SUBSTR(transaction.custbody42,1,2))
k
KingDaGreat
10/07/2021, 5:32 AMHmm, thanks I'll try that later
KingDaGreat
10/07/2021, 8:05 AMNo success here
4 Views