Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community.
Can someone explain me how it works?
An example will be good.
Thanks
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
Hey Hi Yimen,
You can use it like this...
=Sum( {<Date={'$(=max(Date))'}>}Sales)
Hope this works as per your requirement...!!
Ralf - Is that a typo in your expression or does the 'S' perform some other function?
You're right! It's a typo, should be $... I'll change it.
- Ralf
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
Can you enlighten me... what are P and E functions? 🙂
There is a good explanation in the online help...