topic Re: P() and E() in App Development

P() and E()

m_perreault — Tue, 11 Dec 2018 23:43:11 GMT

Hi All,

Was wondering if anyone knows if using P() or E() is faster holding all else equal. Basically I have the option use an expression sum({<[ID] = E({<[Include Flag] = {'0'}>}ID)>}Sales) or sum({<[ID] = P({<[Include Flag] = {'1'}>}ID)>}Sales) and am wondering if one is better than the other.

Thanks,

Mark

Re: P() and E()

tresB — Wed, 12 Dec 2018 04:52:02 GMT

I have never tested to compare their performances. However, I guess if there is a winner, then it should be the p() because that is explicit.

Re: P() and E()

jonathandienst — Wed, 12 Dec 2018 05:45:39 GMT

YMMV - you need to test this with your particular data set as that may influence which expression is quicker (if any).

Re: P() and E()

marcus_sommer — Wed, 12 Dec 2018 10:34:29 GMT

Like the others I never made systematically testings to compare the performance of p() and e(). But if I would do a numerical check and using 0 or 1 instead of '0' or '1'.

Beside this I would also try if the flag couldn't be used more directly to filter/calculate the right data. I mean something like:

sum(Sales * [Include Flag])

- Marcus