Set Analysis Question

[#1]

Hi,

We have a set of records namely R1,R2 etc. Each of them has a Finish Date. Now we want to create a set analysis based on the Finish date to find sales in that month

Eg:

Sum({<Month={"$(=month(Finish Date)"}>}Sales)

This is causing issues as the values for each record should take the corresponding Finish date. But that's not happening now. How to code such that it dynamically chooses the values in that particular field?

Thanks.

[nagaiank]

Probably you need to create a calendar for Finished Date.

Tutorial - Using Common Date Dimensions and Shared Calendars

[rwunderlich]

What are you trying to achieve with the set analysis?

I would think a chart like you are describing would not need any set analysis.

1. Calculated Dimension: =month([Finish Date])

2. Expression: =sum(Sales)

-Rob

http://masterssummit.com

http://robwunderlich.com

[#4]

we have many expressions which uses the finish date.

one expression is to find the first billing Date after the Finish date

min(Billing date> Finish date,Billing Date)

Also another expression to find sales between Finish date and Project end date where Project End date is static.

if we can code for individual value sin the field in the Set Analysis, it will help