You’re offline. This is a read only version of the page.
155
Hi,
Iam trying to display count of salesorder that took place between 0 to 30 days(that 0 to 30 days is difference between sales validity date and current date).
My query is,
With Member [Measures].[NoOfDays] as
'datediff("d",Cdate([Sales orders].[SalesTableDeadlineValidityDate] .currentmember.properties("Caption")) ,Now()) ' select Filter
[Measures].[NoOfDays]>30
and [Measures].[NoOfDays]<60) on
rows
from
[DSBU Head Role Centre]
Iam getting below error,
Execution of the managed stored procedure datediff failed with the following error: Microsoft::AnalysisServices::AdomdServer::AdomdException. Internal error: An external component returned an error (HRESULT = ). The following system error occurred: Type mismatch. .
I need result in below format
NoOFDays SalesId
30 434
31 658
48 65543
59 763
Can any body help.Thanks in Advance.
Regards,
Suba.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (