On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.
How to find distinct sum of amount??
kish
Junior Member
Hi All,
i have birt report data like below
Supplier1
order1 ...... 1000
order1 ...... 1000
order1 ...... 1000
order2 ...... 3500
order2 ...... 3500
sum of total 10,000
the sum of total field is agregated on supplier1 field.Total.sum() function in sum of total picking all the values and displaying 10,000.But i want distinct values to be picked for different orders like 1000+3500 = 4,500 should come as sum of total value.
how to achive this.Any help is appreciated.
i have birt report data like below
Supplier1
order1 ...... 1000
order1 ...... 1000
order1 ...... 1000
order2 ...... 3500
order2 ...... 3500
sum of total 10,000
the sum of total field is agregated on supplier1 field.Total.sum() function in sum of total picking all the values and displaying 10,000.But i want distinct values to be picked for different orders like 1000+3500 = 4,500 should come as sum of total value.
how to achive this.Any help is appreciated.
Categories
- All Categories
- Cloud Editions
- 1 Thrust Services
- cat as link
- 1 Core SaaS Application development
- 10 Developer Announcements
- 15 General Questions
- 33.4K TeamSite
- 141 Application Governance & Archiving
- 15.2K Designing Analytics Reports
- 1K DevShare Downloads
- Core SaaS Applications
- nested parent
- 4.3K Developing Analytics Applications
- 8.8K Documentum Developer Forum
- Media Management developer
- 159 Transactional Content Processing (TCP)
- 1.7K Web Experience Management
- 55 Tempo Social
- 1 XM Fax