In the detail section I have a field of the selection that is created by the report.That field is called 'bedaposo' and is a field from the view.

The view has a column with a key that is unique for every row of the view(like the candidate keys of tables).

The linking I have made with the linking expert brings me some rows with the same key.

I give an example here.

Original view :

bedakey   bedaposo

12345           10

12346           5

12347           20

12348           30

 

query that is generated by the report :

 

bedakey        bedaposo

12345                10

12345                10

12348                30

12349                35

 

I want to be able to generate by formula only and not by running total and grouping by the key a sum of the disticnt values of bedaposo.

In this example

 

10+30+35

 

Thank you!

This doesn't look like a simple add or subtract.  How are you determining that the number is 50 or the number is 21?  Is it based on a range of some sort?

 

-Dell