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.
