I have a text box where in I have to show the average of the product bookings net whose sum(Product bookings net ) is greater then the number that user entered into the input object
I am calculating the count of the account name in a text box by using formula
Sum(if(Aggr(sum([Product Bookings Net]),[Account Name] )>50000,1))
I have to do something like this
Lets say after aggregating with each account name and putting input value as 5000000 data will be like
| Account Name | Product Bookings Net |
|---|
| SOUTHERN CALIFORNIA EDISON | 8034325.35 |
| DIRECTORY OF REALESTATE-PENSION FUND | 7050000 |
| SOCIAL SECURITY ADMINISTRATION | 15070000 |
| SCHLUMBERGER LIMITED, INC | 6000000 |
| HCA INC | 32968190.56 |
| National Grid | 8600000 |
| LUXOTTICA GROUP RETAIL | 18475000 |
| SOUTHERN COMPANY | 11440000 |
| CBP-Customs and Border Protection: DHS | 5320000 |
| microsoft | 17000000 |
| USMC | 6056656.8 |
| LOWE'S Inc. | 8070000 |
| GOV. PERNAMBUCO - ATI | 18000000 |
| COMCOR MOSCOW TELECOMMUNICATION CORPORATION OAO | 10547563 |
| DISTI STOCK | 135980701.7 |
| MTN NETWORK SOLUTIONS | 9429986.82 |
| FORD MOTOR COMPANY | 8465618.853 |
| MGTS | 8635795.8 |
| FORT WORTH ISD | 8486726.08 |
| ZAO REGIONAL INFORMATION NETWORK | 11847440.61 |
| WALGREEN CO. | 5809223.7 |
| NORTHROP GRUMMAN SPACE & MISSION SYSTEMS CORP. | 6129756 |
| BC HYDRO POWER & AUTHORITY | 11669880.48 |
| HARRAH'S ENTERTAINMENT INC | 8166168.75 |
| NORTHROP GRUMMAN SYSTEMS CORPORATION | 9787649 |
| 7-ELEVEN INC | 11328336.18 |
In the above chart I have used the formula =if(Sum([Product Bookings Net])>=$(vPickup),SUM([Product Bookings Net]))
as u see in the above table all the values are greater then 5000000
so now I have to display the average of these products bookings net into the text box
Please try to do it
Thanks in advance
Shashank
