Snapshotting Issue - Formula Summary for Time Periods

Options
richbhar
richbhar Member, ALL USERS, Certified Model Builder Posts: 5 Master Anaplanner of the Year

Hello!

 

We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary.

 

I figured I could create a few extra line items in the source module to capture the QUARTERVALUE of the required line items and use these for imports. But since these are subsidiary views now, I'd need to create a separate import action for each of them. 

 

Is there a better way to achieve this? 

 

Source Module: 

richbhar_2-1621542587741.png 

richbhar_3-1621542722369.png

 

 

richbhar_1-1621542433882.png

richbhar_4-1621543126795.png

 

Target Module :

richbhar_5-1621543756752.png