Expression

[NavinReddy]

Hi Guys Help some one ,im not getting any error with expression

but its not working please any help

=sum({<Month={">=$(=date(YearStart(Today()),'MMMM'))<=$(=date(MonthStart(Today()),'MMMM'))"}>}Actuals)

any error in this expression im calculating YTD

Thanks In Advance

Niranjan

[PrashantSangle]

Hi,

If possible can you share sample app??

Regards,

[swuehl]

Niru Niru, isn't that question close to the question in your other thread:

YTD

Please avoid multiple threads. You already got answers in your other thread, and I am missing a response to my answer there.

[MK_QSL]

Hi Niru,

Instead of lengthy set analysis calculation, you can add a simple YTD flag, below your date field to get the YTD in your UI side.

small example is given below

=====================

Sales:

Load

  Date(Date) as Date,

  Sales,

  If(InYearToDate(Date,Today(),0) = -1,1,0) as YTDFlag

Inline

[

  Date, Sales

  08/09/2013, 80

  10/12/2013, 100

  16/01/2014, 200

  22/02/2014, 220

  24/04/2014, 100

  29/05/2014, 120

  14/06/2014, 1000

];

===========================

Now you can use as below

=SUM({<YTDFlag = {1}>}Sales)

[NavinReddy]

Hi Max dreamer,

Please find the attechment

i not able to find the answer could you please help me to do this

Best Regards,

Niranjan