自定义字段公式 [英] Custom field‏ formulas

问题描述

Hello Everybody

我想请您帮我解决与自定义字段公式相关的以下问题。


 

我已经在自定义字段中为Text24创建了公式，根据Text23上的数字计算所需的小时数。

Text24 =（[Text23] / 25）* 44

 

我还有在Text23中包含字母M（米）的数字。是否有任何选项可以制定公式，用字母M计算数字？


 

示例Text24  =（[Text23（M）] / 60）* 44 或Text23包含 "M" / 60 * 44 ???

 

非常感谢您的帮助和支持。

解决方案

我认为我不明白你的问题。  您是说Text23中的值包含字母"M"吗？比如24M？据我所知，您无法在文本字段中执行数学运算。  即使Text23仅包含数字，我也会得到
，并且您的公式已输入Text24。  

Hello Everybody

I would like to kindly ask you to help me with below question which relates to custom field formulas.
 
I have already created formula in custom field for Text24 which calculates required hours according to numbers on Text23.
Text24 = ([Text23]/25)*44
 
I have also got digits which contains letter M (meter) in Text23. Is there any options to make formula where it will calculate digits with letter M?
 
example Text24  = ([Text23 (M)]/60)*44 or Text23 contains "M" /60*44???
 
Your help and support are really appreciated.

解决方案

I don't think I understand your question.  Are you saying that the values in Text23 contain the letter "M" such as 24M? To the best of my knowledge, you cannot perform math in a Text field.  Even if Text23 contains only numbers Ii get an error with your formula entered into Text24.  

这篇关于自定义字段公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！