Adding two measures together - not working right

[ordendelfai]

Hello,

I have 2 formulas that when used solo, work ok. But when I add them together I get a number that is too small (just a little larger then "RXONLY" formula when used solo).

I am using a second data provider in a table, and the second formula does not work without Multicube.

I am still very new to BO formulas, so any help you can give to make these two formulas add correctly, I would really appreciate.


Formulas:
=Sum(<msr_UniqueMbrCount>) ForEach(<Mbr RDR652 Rider Type Desc> ,<Mbr MBR602 Member Identifier>) + MultiCube(NoFilter(Sum(<msr_UniqueMbrCount>) Where(<Mbr MBR610 Member Flag> = "RXONLY"))))



~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[skrandel]

I thin the problem is that you are uing NoFilter. That function simply doesn't work well when you have multiple data providers.

Steve Krandel
VERITAS Software