Forum Discussion
Formula Help
I have this table: I am attempting to put together a formula that looks at the latest month for a record and calculates the sum of revenue for that month and multiply it by 12. So in this...
v-xjiin-msft not sure what I'm doing wrong:
Anonymous
Could you share your file?
Zubair_Muhammad Unfortunately I don't think I can since my datasets contains company credentials to our CRM. What could be the issue is how the relationships are set up? Data from two different datasets are connected via a unique ID table and the security filter on both tables is set to 'Both'. The data I'm showing comes from two different places connected by the ID's highlighted: