Month to Date

[hammermill21]

Hello everyone,

I'm working on this app and I have been trying different ways to get Month to Date and nothing I do seems to be working. Can anyone give some ideas?

Thanks

I've attached the QVF file.

[sunny_talwar]

Which object are we talking about? What is the expected output?

[hammermill21]

I forgot the details Sunny! Sorry about that.

As you can see there is a filter I added that currently says "Error", that is where I was trying to add the "month to date" selection so that the Table underneath would filter the data for that date range only.  "Dated Passed" is the date I am going by. So I need all the Units to filter by the Dated Passed based on the month to date. Make sense?

[sunny_talwar]

You need this information in a filter object or a KPI object? Right now you are using a filter object with a dimension... is that what the goal is?

[hammermill21]

Yes that's my goal.

[Anil_Babu_Samineni]

In your Application, There is no field Called SALES. What does the field name instead of SALES

[hammermill21]

Hey Anil,

i'm sorry I don't understand what you are asking?

[Anil_Babu_Samineni]

Are you talking about this?

And, Yes i've read reply to sunny as well. Here, You are saying one Calculation showing error. But, I am not gone thru anything which is error.

[hammermill21]

Oh I see, I was messing with it but it should be Units not Sales.

[Anil_Babu_Samineni]

But, When i try simple measure like Sum(Unit) It is not giving any value.