471,092 Members | 1,890 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

OLAP Calulated Measure Total Error

I have 2 fact tables, 1 contains volume of goods sold, and a month key. Each record is for a different store location.

The second fact table contains the number of business days in a month, and the month key.

Now I want to produce a report to show number of business days and the volume for that month. However runing a report returned all NBD records even If there was no volume for that month. So I created a calculated measure to return the NBD only if we had volume.

IIF ( [Measures].[TOTAL VOL], [Measures].[NUM BDS QTY], NULL )

This worked fine, but the NBD totals were wrong. The system totaled the entire NBD table instead of totaling the values returned by my calculated measure.

Does anyone have any ideas for correcting this, or is there another way to do this?

Thanks, Borf
Jan 8 '07 #1
0 815

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Philip Stoev | last post: by
2 posts views Thread by Gadi Refaeli | last post: by
5 posts views Thread by James Conrad StJohn Foreman | last post: by
reply views Thread by YellowFin Announcements | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.