6 Replies Latest reply on Jan 3, 2018 7:25 AM by Nai Louza

# Please help - what is the right formula? (a specific sum)

Hello,

my experience in formula usage is limited ;-) Please help.

In the attached screenshot you see a formula that comes up with 1 if the value of an "order line" is > 50000. That is easy.

But what I need is a formula that comes up with 1 if the value of the whole "purchasing document" (consisting of several "order lines") is > 50000.

Can somebody tell me what the formula must look like?

Thank you in advance,

Roland

• ###### 1. Re: Please help - what is the right formula? (a specific sum)

Try this:

IF { FIXED [Purchasing Document] : SUM(POV in E)} > 50000 THEN 1 ELSE 0 END

• ###### 2. Re: Please help - what is the right formula? (a specific sum)

Hi Roland

In the absence of more to go on, i would strongly suggest that Nai's answer is well worth trying

You will need LOD functions...

Cheers

Mark

• ###### 3. Re: Please help - what is the right formula? (a specific sum)

Thank you Nai. I try and come back here ...

• ###### 4. Re: Please help - what is the right formula? (a specific sum)

Dear Nai,

I got an error because of the part "SUM(POV in E)" in the calculation. And honestly spoken I do not understand the "in E" - but this is not really relevant.

Your hint and the hint of Mark - using LOD functions (which I did not know before) - helped a lot and I was able to solve my problem.

Thank you :-)

Roland

• ###### 5. Re: Please help - what is the right formula? (a specific sum)

Many thanks for feeding back Roland, very kind, and great news you got the problem solved

LOD expressions are relatively new, and so powerful

personally, i found this an invaluable article

and to dive into the specifics - Bora's blog is amazing

There is loads more online, but I hope the above helps

All the best

Mark

• ###### 6. Re: Please help - what is the right formula? (a specific sum)

I'm glad to hear you worked it out! To clarify, the "in E" part was me trying to copy the euro symbol in the name of your field with my American keyboard