Forum Discussion

ChavdarG's avatar
ChavdarG
Frequent Visitor
5 years ago

Revenue Recognition Automation

Dear all,   I have hit a wall with this one and need help from the community. Example file here: https://drive.google.com/file/d/17mOH9IoM2y_l89wcaN04KdSED5wLo695/view?usp=sharing   The idea is ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  ChavdarG ,

 

I cant match your data with your requirement,could you pls check again and advise what is your expected output based on your sample data?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

ChavdarG's avatar
ChavdarG
Frequent Visitor
5 years ago

Hello,

 

The pivot table in the sheet displays Final Volumes, the number of which is currently 389,742 because there is a cost center missing (62037). Should be 404,742 including 62037. It is missing because Final Volumes is a calculated column based on the data of the FactTable. However, the sales of 62037 come from the Sales table. They are not in the FactTable because these are shipments from previous periods recognized as sales in the current period.

The first thing I need to do is add any quantities recognized as sales from the Sales table, that are missing in the FactTable, to the Final Volumes formula.

 

I guess may be not that straightforward or I cannot explain it well. Does it make sense now?

 

Thanks,

Chavdar