Skip to Content
0
Former Member
Nov 13, 2012 at 03:00 PM

How to select just a determined values?

20 Views

Hi,

if I've the following ratios with these values:

ratio1 ratio2

2 65

5

23 7

4

7

l'd like to work with the records where the ratio2 is not empty. For example, if both ratios are defined as SUM Aggregation I'd like the result was the following:

ratio1 ratio2

2 65

5

23 7

4

7

=========

25 72

Moreover, I need to hide the records which values are empty:

ratio1 ratio2

2 65

23 7

=========

25 72

Can anybody help me?

Thanks a lot.