You must exlude leaf members from this formula using an IIF statement and
the CalculationPassValue function in the elst clause to refer to the raw
fact data...
Thierry
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Derrick" <derrick1298 (AT) excite (DOT) com> wrote
Quote:
I'm trying to get a very basic custom rollup formula working for a
parent-child dimension.
One dimension, drug, one measure sales, simple p-c dim. With no custom
rollup formula, works as expected. I put in the following, and get empty
values (not ERR though) Any ideas?
SUM([Drug].CurrentMember.Children, Sales)
I do not want to use RollupChildren because eventually I want to specify
individual rollup % using a weight stored in a member property...
TIA!
Derrick |