Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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