YTD Issue ?

[#1]

Hi All,

I have created a Gauge chart for comparing YTD & LYTD, I have impemented that it will show directly YTD & LYTD with out any Selection of Year & Month, but If I am Selecting Year or Month , The Values are CHanging , But I dont want to change...

Can any one help me on this...

I am Giving Sample YTD EXpression for Example:

((Sum(If([Invoice Year] = Year('$(vMaxDt)'),[Invoice Turn Over]))+

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

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*',[JV_Finance INR]))+

sum(IF(YEAR(RJV_TRAN_Dt) = Year('$(vMaxDt)') AND [RJV Dr/Cr] = 'C' AND [RJV CODE] LIKE '301*',[RJV_Finance INR])))-

(Sum(If(Year(CN_TRAN_Dt) = Year('$(vMaxDt)'),[CN_Finance INR]))+

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

sum(IF(YEAR(RJV_TRAN_Dt) = Year('$(vMaxDt)') AND [RJV Dr/Cr] = 'D' AND [RJV CODE] LIKE '301*',[RJV_Finance INR]))))

Regards,

Heather

[marcus_sommer]

To be independent from selections you need set analysis expressions - have a look in the help and for example here:

Set Analysis

Set Analysis Wizard Tool

Set Analysis: syntaxes, examples

- Marcus