Skip to Content
0
Former Member
Nov 21, 2008 at 05:57 AM

Logical expression in a Query

14 Views

Hi.

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.

Cheers

Anand