Hello, Thank you for your response. We use XSL stylesheet as the RTF limits the amount of columns we can display to our users. Having said that though, what I'm trying to do is set the default in the prompt to be 'previous month'. So in the parameters section of the data model, we've used the '{$SYSDATE()$} variables but I…

CAST("Win Loss Facts"."# of Won Opportunity Revenue Lines" AS DOUBLE) / CAST ("Pipeline Facts"."# of Closed Opportunities" AS DOUBLE) Still get 1. I'm beginning to think it's something with the way the data is structured by Oracle. Is that possible? 

This is what I just tried and it's not working TRUNCATE(FILTER("Pipeline Facts"."# of Opportunities" USING ("Opportunity"."Status Name" = 'Won')), 4)/TRUNCATE("Pipeline Facts"."# of Closed Opportunities", 4) I will try your above suggestion. Thank you. 

I understand. I apologize. I was not clear in my response. I did move the decimal place out in the formatting and it is still not working. I tried this formula too. TRUNCATE(FILTER("Pipeline Facts"."# of Opportunities" USING ("Opportunity"."Status Name" = 'Won')), 4)/TRUNCATE("Pipeline Facts"."# of Closed Opportunities",…

This was not very helpful. But thanks anyway. 

The Time dimension works for the current dates. I'm trying to get the quarter of the "Expected Close Date". The Secondary Date dimensions have a Quarter for the Actual Close Date. What I'm trying to do is show the Quarter of the "Expected Close Date" of Open Opportunities. It doesn't appear there is an out of the box…

Hello, I had to do something similar with activities on opportunities. One of the ways I tried to solve was this: Build an analysis that shows all of the people that DO have time cards for last week. Then, build another analysis and use a filter on it that says "ID DOES NOT equal" one that is on the first analysis you…

I found a solution from Fernando Paes. It worked! Thank you Fernando. " the way I would do it, you don't need that column with the formula. Create a 1st report with just two columns: Opty Name and Opty Id and a filter based on Activity Due date > today (so it gives you the opportunities with an activity in the future).…

This sounds like a great solution. I tried it but got an error. :( . See attached.

Try adding a fact from each dimension of each SA. If you don't actually need the facts, you can hide them in the criteria or exclude them from the results. Additionally, in the Advanced properties, click the "Dimensionality" box and Apply SQL. This may solve the problem. Hope this helps!

I think you may be right. It could be a data type issue in the database. We will probably have to log an SR. Thanks!

We tried this too. It doesn't work for us. If it did, I think it would be cosmetic only. Thanks though.

Thank you. We tried this with the Case statement. See screen shot. It doesn't work. Thanks.

Sorry. We tried that as well. It doesn't work.

Additional question regarding this issue: Beyond just formatting, is there a way to actually restate the column so that is actually just a date? The data formatting is just cosmetic. I'm trying to do a Case statement on 2 date columns. When one is >= another, then I want it to show as "overdue". The problem is that it is…

Additional question regarding this issue: Beyond just formatting, is there a way to actually restate the column so that is actually just a date? The data formatting is just cosmetic. I'm trying to do a Case statement on 2 date columns. When one is >= another, then I want it to show as "overdue". The problem is that it is…

This is a great workaround. Thanks! I still think the function is not working as expected and that could just be a bug with the Sales cloud OTBI but your suggestion gets me what I need. Thanks again.

Thank you! It is not working in Sales Cloud. I will post to the Sales Cloud Analytics forum. Maybe it's a known bug.

I have figured this out. The developer of the report made a custom formula using a URL and then made the data format HTML. It appears as though it is a "Drill" but really it's a URL in the forumula with HTML data formatting made to look like a "Drill". I know how to fix if needed.

I tried all of that. I cleared my cache. Report is saved (has been for weeks). I logged out and back in. I changed it back to "Drill" and saved it and then back to "None" again. Nothing is working. Should we log an SR? Thanks, Stephanie