Insert a calculation in a rule instead of a field

Hi,

Can i insert a calculation in a rule instead of a field??

Now i write a calculation in a field of a excel and fusion pro read the result.

Would i that fusion pro make the calculation by most field to excel.

For example now in field A2 i write =B2+(C3/H4) after i want write in a rule (Field(" Prezzo") +(Field("Vendite")/(Field("Prodotti")... is it possible??

Thanks

Hi,

Can i insert a calculation in a rule instead of a field??

Now i write a calculation in a field of a excel and fusion pro read the result.

Would i that fusion pro make the calculation by most field to excel.

For example now in field A2 i write =B2+(C3/H4) after i want write in a rule (Field(" Prezzo") +(Field("Vendite")/(Field("Prodotti")... is it possible??

Thanks

Sure. You want to use either the Int function (for whole numbers) or StringTo Number (for non-integral numbers), something like this:

return StringToNumber(Field(" Prezzo")) +(StringToNumber(Field("Vendite")) / StringToNumber(Field("Prodotti")));