Thanks for the responses.
I was looking for a solution where MSTR will allow me to create a metric using code that does this: '1/31/2002' = 21, '2/28/2002' = 19, ... etc., and I know this would require periodic maintenance. The solution with this formula was provided for me in a metric by our...
Yes, the system stores 36 months of data which, which can be aggregated by any combination of months, but I will be reporting by month and displaying 13 months product activity.
Our systems people now tell me that volumes are stored by customer account, by product. To find out if there are more...
Volume fact is stored at the detail (product) level, and average volume for each month would be reported at that level. Average monthly volumes will always be reported by month, by product. All products are on the same level. I hope this ansers your questions.
Thanks.
Jerry
I am working with MSTR 7.2.2. The system will not allow me to create facts or tables. As a MSTR newbie, I am trying to learn how to create an object that will allow me to use the number of business days in a month in a calculation. "Month" is one of the date attributes available to me. I know...
Your code:
=IIf([txtNC]>=[txtAvgNC150],"Outstanding",(IIf([txtNC] Between [txtAvgNC150] And [txtAvgNc125],"High Acceptable",IIf([txtNC] Between [txtAvgNc125] And [txtAvgNc75],"Acceptable",IIf([txtNC] Between [txtAvgNc75] And [txtAvgNc50],"Low...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.