SUMMARY OF FOUND SET ISSUE
MY PROBLEM AT HAND, IS THAT IN MY TRAILING GRANS SUMMARY, I HAVE FIELDS THAT ARE SUMMARY FIELDS BASED OFF OF A CALCULATED FIELD ABOVE. THIS WORKS PERFECTLY. I THEN HAVE ANOTHER LAYOUT THAT HAS A RELATIONSHIP WITH THESE SUMMARY FIELDS AND THIS DISPLAYS ALL OF MY DATA IN ($), WHICH IS WHAT I WANT. THE ISSUE COMES WHEN I DO A PERFORM FIND ON MY LAYOUT "PROJECTS". THE SUMMARY FIELDS IN THE TRAILING GRANS SUMMARY SHOWS THE CORRECT INFO BUT WHEN I GO INTO MY LAYOUT "MARKETING" THE DATA IS NOT CONSTRAINED TO THE FIND AND INSTEAD IS SHOWING ALL OF THE DATA. I WOULD LIKE TO HAVE IT SHOW ONLY FIELDS THAT HAVE AN AMOUNT IN THE TRAILING GRAND SUMMARY. I AM STUCK ON THIS AND NEED SOME ADVICE.
If you are using calculated fields such as MAX(field) then you should be using Summary fields instead that are constrainded to the found set. If not maybe you could provide a little more information.