Newbies SeanO Posted December 2, 2020 Newbies Share Posted December 2, 2020 Greetings. Reaching out for help as I'm staring at a brick wall currently. The more research I've done the more lost I've become. Primary Table is a List of ALL Active Matters. Each Matter is Unique. Portal is a List of Related Nominations. Relationship is the MatterID Two calculations are performed for Every Matter & Displayed/Saved in the Primary Table (Save Preferable) 1.1 Count the Number of Nomimations For the Matter (SUPPORTCOUNT). 1.2 Add the Value of each Claim per Nominations (SUPPORTVALUE) The above Calculations are for the Primary Table & Preferably a Saved Value. The Calculations Must be part of the visible Primary Row. eg: MATTER (PRIMARY) MATTERID - NOMDATE - MATTER - SUPPORTCOUNT - SUPPORTVALUE - APPLICANT - APPLICANT VALUE ... NOMINATIONS (PORTAL) MATTERID - NOMDATE - NOMINATIONNAME - REFERENCE - VALUE ... The final version of the above, includes a Nomination Date in both The Primary Table and the Portal. If the Nomination Date is Blank, then the Count Calculation needs to Exclude that record from the Count total. To further confuse matters, the Applicant in the Primary Table, is also a Nominator (Primary Nominator - can be only One) and may not give their Support, in which case NOMDATE would be Blank and would be Excluded from the SUPPORTCOUNT Total. I readily admit I'm missing something basic but I'm too deep in the woods now to count the trees. Happy to give progress feedback. Many thanks in advance for your assistance. Link to comment Share on other sites More sharing options...
This topic is 853 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now