Tagged with scaling-values - Visokio Forums http://forums.visokio.com/discussions/tagged/scaling-values/feed.rss Mon, 30 Oct 17 16:12:01 -0400 Tagged with scaling-values - Visokio Forums en-CA Formula: Scaling values in Field Organiser...or separate Formula field? http://forums.visokio.com/discussion/2952/formula-scaling-values-in-field-organiser...or-separate-formula-fields Mon, 08 Jun 2015 11:18:41 -0400 dpawley 2952@/discussions
I want to just convert the number from Hectolitres to Litres.

Cheers

Danny]]> Idea: Validate Data - scale/replace an incoming field? http://forums.visokio.com/discussion/2124/idea-validate-data-scalereplace-an-incoming-fields Mon, 06 May 2013 13:06:44 -0400 cmollo 2124@/discussions VALUE(this same field) / 100.0
Of course "this same field " is a circular reference, not a valid formula field reference. So, the best I can figure out is to use two Field Organizer blocks. In the first block I create a new field, let's call it [field2], with a formula:
VALUE[field1] / 100.0
Then in the second block, I delete field1. Is that the best solution, or is there a better solution?

Thanks! Chris]]>