Comaparing amounts with Set Analysis

[#1]

Hi!

I'm trying to compare the Hours for a period and only show those > 100000.

Can anybody explain why my syntax is wrong?

sum( {"=sum{$<PeriodCounter = {"$(#=max(PeriodCounter))"}>} REPORTED_HOURS )> 1000000"}>} REPORTED_HOURS )

Thanks!

Johan

[#2]

Hi Johan,

please provide an example we can work with.

Thank you!

Rainer

[#3]

Hi!

Actually my example is fetch from the Help text. This is the syntax I modified.

sum( {$<Customer = {"=Sum({1<Year = {2007}>} Sales ) > 1000000"}>} Sales )
returns the sales for current selection, but with a new selection in the "Customer" field: only customers who during 2007 had a total sales of more than 1000000.

This not working either.

/Johan