This content has been marked as final. Show 9 replies
I need some help with load scripts:
I have a standard load script loading some data from excel sheet which is fine, i have a rather complicated if structure to calculate a value, lets call it 'Calculated Value A' which i save to the table structure, this all works great.
However in the same load script i want to access 'Calculated Value A' which I have just created and use it in further calculations, rather than just repeating the whole complicated if structure again is there a way to gain access to the value in the field that has just been created?
if ( if ( if ( etc ))) as [Calculated Value A]
if [Calculated Value A] = 'Yes' then do something