Simple Mathematical Equations in Domo

Thank you @GrantSmith for the quick reply. The difficulty lies with referencing a column. I have two unlinkable and somewhat dirty datasets that our team is working to correct, but the numbers are all there. I want to get MMR using the following logic (imagine the title says MMR, not Avg revenue per acc):

EDIT: I should also specify that the "avg revenue per account" part of this calculation takes into account the whole period, the accounts in a given period takes into account a single month.

Yes I understand that, thank you for making sure. I am not trying to reference columns. I want to use manually entered numbers as a sort of "snapshot" instead of referencing specific columns. I have to take the amount of accounts from one dataset and the revenue figures from a different one, without any way to link the two.

Yes the data is time bound. One is a dataset via email, and the other is a live warehouse. The email dataset records the entirety of revenue for a single date, while the live warehouse is continuously updated.

The issue is that due to nonexistent accountability mechanisms in the recording of our datapoints from the emailed dataset, that some transactions are recorded all at once instead of in their proper dates. For example, someone would think to themselves, "Why does it matter if I record 1k of revenue in the current month of July if they are all for the same billing code?"

From the above situation, some of our revenue could be misattributed to July instead of June.

These may be able to be linked using dates but I do not know how to transform multiple days, months, and years from the live warehouse and compare it to the emailed dataset. Would it account for years as well? Should I use a date scaffold?

I believe I figured out the issue, it was in fact the aggregation. When summarizing using real numbers, you have to change the aggregation to an average rather than a sum to get the accurate numbers.