Help with Sum function / Creating a Profile
I am trying to create a profile to spread revenues by client (i.e. When a client signs a contract in the future, when will the revenues occur based on past performance.
First I have a module that has historical revenues, by brand account, plotted on two dimensions - Contract Cohort (month the contract was signed, a list I created) and Time (revenue recognition). Looks like this (single brand selected, redacted with black marker):
Then I created a cohort/month mapping module to a list called Months for Waterfall - which is the profile list. This evaluates what profile month the combination of the cohort and period relates to:
I am then trying to aggregate this into a profile module that has the account and the months for waterfall as dimensions. The allocation % would be Historical Revenue $/Historical Revenue $[select:Total All Months for Waterfall(sic)]. It is evaluating to $0 and I can't figure out why. It seems to have to do with the time dimension but I can't figure it out:
I feel that this should work as the source and result both have the accoount/brand dimension, and the time/cohort dimensions are mapped via the Attributes-Cohort Month module - but alas, its not working. Any help would be appreciated.