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

[Etwo_Cargo]

Hi,

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

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

[RezaRaoofi]

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]

@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_KULACOGL]

@Etwo_Cargo

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

[Etwo_Cargo]

@Levent_KULACOGLU

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