((Current Date - Start Date)/(End Date - Start Date))*Contract Amt 
Author Message
 ((Current Date - Start Date)/(End Date - Start Date))*Contract Amt

We have a cube consisting of a fact table with a measure of Contract Amt ($)
plus some other accounting numbers related to projects and a couple of
dimensions (actually more but that should be enough information for this
question) - Time and Projects with a project number as a key.

We are trying to create the following calculated member:

((Current Date - Start Date)/(End Date - Start Date))*Contract Amt

Where

  a.. Current Date is a member of Time dimension (either default or
explicitly created)
  b.. Start and End Dates are properties of a project number (should they be
defined as custom properties or some other way?)

What is the correct syntax for this calculation?

Can it be a member of measures dimension?

Thanks much for any helpJ

Alex Pitko



Fri, 09 May 2003 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. How do I get the start date and end date of week #35

2. Calculate Start Date from End Date Help

3. Calculate difference between start date and time and end date and time

4. Multiple Dates by choosing Start and End Date

5. Need to find start date of the month and enddate of the month given a date

6. Dates, Dates, & More Dates

7. SQL: Select some data with date criteria, but only by Date part of date field

8. DATE DATE DATE Filemaker and Month names

9. Q:get current date and then create date range

10. Where Date = Current Date

11. MYSQL - DEFAULT DATE as CURRENT DATE

12. Fill a date field with the current date when a checkbox is checked


 
Powered by phpBB® Forum Software