About cecilia_peterss

Hi Brett, I'm not sure how you set your module to quarterly as I can only see Year/Month/Day in the Line Item Time Scale (would be interesting to find out), but I've built a small scenario to transfer year to month that you should be able to use for quarters instead. I first created a simple yearly module to simulate the old setup and then a monthly module with the same line items as the yearly one. (A bit of a pain if you have many line items, but you should be able to export your old module to Excel and import or copy the line items to your new module.) Then I wrote a formula that would pick up the aggregated value from the old model and divide by 3. As you can see, I've written it for Jan, Feb and Mar and then been lazy and just set one Else, but of course you would retrieve different source quarters for Apr-Dec as well. Hope it helps! /Cecilia ... View more

Hi Gideon, I think assigning Selective Access your Country list could help you. Then you can grant write access to all countries and read access to the dummy countries. /Cecilia ... View more