SET ANALYSIS : Nested expressions

[#1]

Hello community.

Can someone explain me how it works?

An example will be good.

Thanks

[rbecher]

Hi,

this is an example:

sum({$<Customer={"=sum({l<Product={'A'}>} Sales)>0"}>} Sales)

It represents the sum of all Sales for the set of Customers who purchased Product 'A'.

- Ralf

[rahulgupta]

Hey Hi Yimen,

You can use it like this...

=Sum( {<Date={'$(=max(Date))'}>}Sales)

Hope this works as per your requirement...!!

[nathanfurby]

Ralf - Is that a typo in your expression or does the 'S' perform some other function?

[rbecher]

You're right! It's a typo, should be $... I'll change it.

- Ralf

[nathanfurby]

OK thanks - I'm still relatively new and quite recently discovered the P and E functions. Wanted to make sure I wasn't missing out

[#7]

Can you enlighten me... what are P and E functions? 🙂

[rbecher]

There is a good explanation in the online help...