The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Monthly and Quarterly percentage
hi Experts,
i've a member formula (stored calc) to calculate %. My scenario type is periodic. i'm calculating % for various P&L accounts. M1,M2 and M3 %s is correct but for quarter, system is addin...
HI, I suggest making the member dynamic calc, so that you can specify a formula for both the V#Periodic and V#QTD cases. The stored formula is not going to work: if you calculate on V#QTD, data calculated quarterly will be allocated to the dependent periods (the system adjusts the periodic values so they aggregate correctly), so the % on the M1/M2/etc. would not be correct anymore.
HI, I suggest making the member dynamic calc, so that you can specify a formula for both the V#Periodic and V#QTD cases. The stored formula is not going to work: if you calculate on V#QTD, data calculated quarterly will be allocated to the dependent periods (the system adjusts the periodic values so they aggregate correctly), so the % on the M1/M2/etc. would not be correct anymore.