Adding Values between Two Dates

  • Hi.

    I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate.

    For Example:

    =SUM(

    IIF(Fields!rpt_date.Value = Parameters!RptDate.Value

    And Fields!Mot.Value

    Like "*In*", Fields!Total.Value, 0), "CoMethod"

    )

    I want that Fields!Total.Value to be the Start of Month(Date) and Parameters!RptDate.Value

    Thanks.Arman

  • Arman Khan (7/11/2012)


    Hi.

    I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate.

    For Example:

    =SUM(

    IIF(Fields!rpt_date.Value = Parameters!RptDate.Value

    And Fields!Mot.Value

    Like "*In*", Fields!Total.Value, 0), "CoMethod"

    )

    I want that Fields!Total.Value to be the Start of Month(Date) and Parameters!RptDate.Value

    I'm not sure what you mean by "values". Could you clarify?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply