on 11-21-2008 5:57 AM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.