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