Showing results for 
Search instead for 
Did you mean: 

Logical expression in a Query

Former Member
0 Kudos


I have to build this relation in a query. I have two key figures F, S.

This is the logic:

If F=0 and S=0, then 0, If then IF F=0, S>0 THEN 100, IF F>0, S>0, THEN S/F

This is how I have built the syntax

(F=0 AND S=0)0+(F=0 AND S>0)100+(F>0 AND S>0)*(S/F)

The issue, when I use this expression here, only those values where F>0 AND S>0 show values. The rest of them show 'X' meaning infinite.

Suggestions please.



Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Try including conditon check for :

(F> 0 AND S = 0) what should happen ??? May be that is your case.

May be last condition you can put +(F>0 AND S>=0)