NetWebBrowse formula

[rupertvz]

Hi Guys,

I have an extremely long formula to use in a NetWebBrowse.  I am unable to truncate.
13 periods, and 4 x values for each period to show a total in a single column.

The Display field of the column automatically trims the formula.
Is there a way that I can embed code to calculate a total into a local variable to show in the NetWebBrowse?

[kevin plummer]

Try this...

Create a local variable string, long enough to fit your formula + some more

Add it to the template where you are trying to put your formula

search your source code for this variable and the first embed before it add your formula to the local variable.

cheers,

kev

[Bruce]

hi Rupert,

template fields have limits, so Kevin's idea is the right one.

cheers
Bruce

[rupertvz]

Hi Kevin,

Thanks for your help ..

I created a local variable (string 2000)
Set the variable LOC:SOH = 'myexpression' (to store the full expression in the local variable)
But it didn't tally / show the total in the NetWebBrowse.

I then used the same embed point, and set the variable
LOC:SOH = myexpression
(basically adding the "value of the expression" into the local variable, instead of the formula itself)

This worked :-)

I am sure you meant that I should store the full expression in the local variable and not the value ... ?

[Bruce]

no, he meant you should set the value - as you did.

cheers
Bruce