set analysis

[#1]

Hi,

I am trying to optimize a calculation because it is not always calculating correctly.

I Need to Change it into a set Analysis calculation but I dont get it to work.

sum((if (xrefNr like '6*' and linetype=158 and linetype='158' and xref_GRPCODE='2KRE' and not (doccode like 'Z*' or doccode like 'BANK*' or  doccode like 'A*'),Buchungsbetrag,0)))

Does somebody have an idea how the set Analysis must look like?

Very much thanks in advance.

Chris

[swuehl · Accepted solution]

Try maybe something like

Sum(

{<xrefNr = {"6*"}, linetype = {158}, xref_GRPCODE = {'2KRE'}, docode -= {"(Z*|BANK*|A*)"}>}

Buchungsbetrag)

[sunny_talwar]

May be this:

Sum({<xrefNr = {'6*'}, linetype = {158}, xref_GRPCODE = {'2KRE'}, doccode -= {'Z*', 'BANK*', 'A*'}>} Buchungsbetrag)

[Kushal_Chawda]

Hi Stefan,

what is difference between docode -= {"(Z*|BANK*|A*)"} & doccode -= {'Z*', 'BANK*', 'A*'}  ?

[#5]

Thank you very much to all of you.

All Solutions worked 🙂

[swuehl]

Besides that I misspelled doccode?

I've used a single field modifier list element, a compound search including three searches, instead of three set modifier list elements that each contain a search, but I don't think that makes a big difference.

Mine is shorter

[sunny_talwar]

shorter by the count of characters?

[Kushal_Chawda]

Yes, that's what I wanted to know with regards to performance. Thanks