Forum Discussion
Solved
Calculations on Calculated Table
Any way to create calculations on this table? I need to divide the Donations by the # fields.
Donations by Customer by FY =
SUMMARIZE(
'Opportunity Contact Role',
'Opportunity Contact Role'[ContactId], Contact[Full_Name_with_Nickname__c],'Opportunity Contact Role'[Role],
"2023 Donations", CALCULATE(SUM('Opportunity Contact Role'[Amount__c])+0, 'Opportunity Contact Role'[Close_Date__c] >= DATE(2022, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] <= DATE(2023, 6, 30)),
"2024 Donations", CALCULATE(SUM('Opportunity Contact Role'[Amount__c])+0, 'Opportunity Contact Role'[Close_Date__c] >= DATE(2023, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] <= DATE(2024, 6, 30)),
"2025 Donations", CALCULATE(SUM('Opportunity Contact Role'[Amount__c])+0, 'Opportunity Contact Role'[Close_Date__c] >= DATE(2024, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] <= DATE(2025, 6, 30)),
"2023 # of Donations", CALCULATE(COUNT('Opportunity Contact Role'[Close_Date__c])+0,'Opportunity Contact Role'[Close_Date__c] >= DATE(2022, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] < DATE(2023, 7, 1)),
"2024 # of Donations", CALCULATE(COUNT('Opportunity Contact Role'[Close_Date__c])+0,'Opportunity Contact Role'[Close_Date__c] >= DATE(2023, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] < DATE(2024, 7, 1)),
"2025 # of Donations", CALCULATE(COUNT('Opportunity Contact Role'[Close_Date__c])+0,'Opportunity Contact Role'[Close_Date__c] >= DATE(2024, 7, 1) && 'Opportunity Contact Role'[Close_Date__c] < DATE(2025, 7, 1))
)
I need to be able to divide Donations by # (ex. 2023 Donations/2023 # of Donations)
I can't seem to find the appropriate syntax to do this on my calculated table.
I can't seem to find the appropriate syntax to do this on my calculated table.
Hi PBrainNWH - Can you please share some sample data for reference with expectations.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
1 Reply
Hi PBrainNWH - Can you please share some sample data for reference with expectations.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!