Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

query calculation

Hi Gurus,

how can i implement the logic below in a global definition of a query

IF 'A' > B' THEN 0

OTHERWISE as below

"( 1 - A' / B' ) * 100"

Highlighted in double quots is the current calc for the key figure..

Ur reply will be appreciated. Thank u

Dave

Former Member
replied

Hi Dave:

Create a New Calculated Key Figure. In the formula, write this Code:

(A>B)(0) + (NOT(A>B))((1-(A/B))*100))

Let me know if you find any issues.

Good day

Ram Chamarthy

Message was edited by: Ram Chamarthy

Message was edited by: Ram Chamarthy

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question