Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
colliers_sn
Contributor II
Contributor II

Aggr function usage.

Hi

I have attached the QVW file and the Sample data file and my request is in the QVW.

Any help is highly appreciated.

Thanks much.

6 Replies
sunny_talwar

Can you specify what your expected output is?

colliers_sn
Contributor II
Contributor II
Author

Lease ID 446 should show Exp*Frequency amount for subspace ID 669 as that is the highest amount compared to subspace ID 510.

Thank you.

sunny_talwar

What that amount needs to be? I am looking for a number I should be aiming for?

colliers_sn
Contributor II
Contributor II
Author

36,247 whIch is sum of Exp*Frequency for 610

colliers_sn
Contributor II
Contributor II
Author

I mean 669 *

settu_periasamy
Master III
Master III

Maybe like attached?