Hi, I is possible to use MATH EXPRESSION ins...

expressions
(Etwo Cargo) #1

Hi,

I is possible to use MATH EXPRESSION inside of email body like

<<([kg]/[pc]*[pc1])>> is that formula true?

(Reza Raoofi) #2

You should be able to use all regular expressions inside <<…>> tags, however sometimes it might make sense to create a Virtual Column that calculates that formula, and then just simply enter <<[VirtualColumn]>> in the email template.

(Etwo Cargo) #3

@RezaRaoofi Dear Reza, Thanks for your interest. Here is the formula and error message.

<<(([TTL KG]/[TTL PC])[Missing pieces number])>>

Workflow rule ‘MSCA’ field ‘Body’ expression ‘(([TTL KG]/[TTL PC])[Missing pieces number])’ is invalid due to: Arithmetic expression ‘(([Ttl KG]/[Ttl PC])*[Missing pieces number])’ has inputs of an invalid type ‘Unknown’.

(Levent KULAÇOĞLU) #4

@Etwo_Cargo

With arithmetic calculations, pay attention to have all parameters of the equation be either a number or a decimal

(Etwo Cargo) #5

@Levent_KULACOGLU

Master ! Thanks a lot. Was my mistake about type column.