Something wrong with the Expression

[#1]

Hi All:

Not sure where I went wrong with the Expression in the MTD variance

The Expression is as follow:-

Sum (if(Year= year(CurrentDate) and Month1 = month(CurrentDate)
and (transdate)<= CurrentDate,[Day Variance]

My problem is on the Day Variance as the above expression...

The Day Varaince = Crate To - Crate From

Day Variance is in the Expression (Colum 3) and MYD Variance (Colum4)

After the calculation in the expression (Crate TO – Crate From) I should be able to use the field right?

Hmmm... something is wrong

Could someone please share some light?

[perumal_41]

Sum (if(Year= year(CurrentDate) and Month1 = month(CurrentDate)

and (transdate)<= CurrentDate,[Day Variance]))

[#3]

Hi Perumal A:

Thanks for your help but the issue is on the Day Variance...

Not about the )))...

When [Day Variance] is key in there is an Error on top the expression:- Bad Field name : [Day Variance]

Not sure what went wrong....

[perumal_41]

please upload ur file.

[#5]

Hi Perumal A and All:

I just up load the file...

The issue is in the MTD variance.

Where I use the Day Variance for my MTD variance.

Can take a look at the Expression in MTD variance.

Thanks all