high light ?

[#1]

Hi All,

I have created some charts in a tab..but I need not to be high lighted one YTD Chart on Selection of any filter like year & month..

it should be constant it should be updated to current year to till date..

can any one help me on this..

Regards,

Kacy

[#2]

I am getting Error ..

Please Convert this 2 lines So that I will convert accordingly,

sum(IF(YEAR(DN_TRAN_Dt) = Year('$(vMaxDt)') AND [DN Dr/Cr] = 'D' ,[DN_Finance INR])))+

sum(IF(YEAR(JV_TRAN_Dt) = Year('$(vMaxDt)') AND [JV Dr/Cr] = 'C' AND [JV CODE] LIKE '301*',

[Anonymous]

Heather,

You first have to create a field containing the YEAR(DN_TRAN_Dt) in your script code, let's name it [DN_TRAN_Dt Year] . And the same for JV_TRAN_Dt. Once it done, the expression will be:

=Sum({<[DN_TRAN_Dt Year] ={"$(=Year('$(vMaxDt)'))", [DN Dr/Cr] ={'D'}>} [DN_Finance INR])

+Sum({<[JV_TRAN_Dt Year] ={"$(=Year('$(vMaxDt)'))", [DN Dr/Cr] ={'C'}, [JV CODE]={"301*"}>} [DN_Finance INR])

I recommend you this: Set Analysis

Hope it helps.

Marc.