Set Number field from calculation

Jennifer Fink

Hello.

I have 3 UDF Amount fields that system information says are number fields. I want to populate field 3 with the difference between field 1 and field 2.

When I tried SET($[$Field3.0.NUMBER|($[Field1.0.NUMBER]-$[$Field2.0.NUMBER])); I get the following error message:

Macro error in UF-104: System.Exception: Input string was not in a correct format.
 [Macro Command: Set($[$Field3.0.NUMBER]|($[$Field1.0.NUMBER]-$[$Field2.0.NUMBER]))]

Macro Enviroment parameters: [Current Form: 320 - Opportunity][Source Row: -1]

Then I tried:

@STORE1 = ($[Field1.0.NUMBER]-$[$Field2.0.NUMBER])

SET($[$Field3.0.NUMBER|@STORE1) and then got the error message: 

Macro error in UF-104: System.Exception: Input string was not in a correct format. [Macro Command: Set($[$Field3.0.NUMBER]|20000))]

Macro Enviroment parameters:[Current Form: 320 - Opportunity][Source Row: -1] [Target Row: -1] [Break: False]

Note: I have Field 3 set to be read only via Boyum.

Thanks in advance. I feel like this is a very simple question but I'm drawing a blank.

Comentarios

1 comentario

Fecha Votos
  • Comment author
    Geoff Booth

    Try: SET($[$Field3.0.0|@STORE1) ; // Even though Field3 is a Number the Boyum Set command likes to use a string to set it - Maybe someone else has a better explanation.

    Not sure why you have the field set to read-only as this may prevent the update as will. it does add a Enable command just before you set the field and a disable command afterwards.

    0

Iniciar sesión para dejar un comentario.