Set analysis differ in expression and script

[#1]

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

[#2]

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