Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Element Functions P() and E()

I understand that P() uses all possible values and E() uses all excluded values.  however, what is not clear to me is whether functions refer to the user selected values or to the entire document.  Which is it?

1 Reply
fkeuroglian
Partner - Master
Partner - Master

Hi, depends

if you select something , the function  is on the selected register but if you do not select, the function will be in the whole registers.

Example:

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )


if you check some filters the total of recors will decrease and the function will be for the selection only


if you do  not select any filters, the function will be in the total of records


see this


Good luck


Fernando


P() &amp; E() and where do you use them?