Set analysis differ in expression and script

Tue, 13 Nov 2012 21:56:23 GMT

Hi,

I am using

sum( {$<ProductID2 = {$(=max(ProductID2))} >} ListPrice )

in a chart expression and it works fine.

When I use the same code in a script I get an internal error in the {$(=max(ProductID2))} - part.

set vMySales = sum( {$<ProductID2 = {$(=max(ProductID2))} >} ListPrice )

How come it does not work the same way?

Kind regards

Peter

Re: Set analysis differ in expression and script

Tue, 13 Nov 2012 23:06:34 GMT

Hi,

I thought you always had to surround strings with double quotes in a SET statement.

Also: is your ProductID2 field available at the time of calculation?

Dion Verbeke

Sr BI Consultant