if then else returning conflciting results

[#1]

Hi,

I have created an if then else statement as below

=if (monthstart(today())= Max([Template Date]), [Revenue Target Value])

the stamenet looks at the first day of the month(01/08.2016) and picks the matching template date(there are lots) and should return the target value record.

However, it returns -  for all records that have template date records of 01/01/2016, 01/02/2016 etc

If I change the if then else statement to

=if (monthstart(today())= Max([Template Date]), 1, 0)

it display a 1 for all records were the month start = the max template date

Hence it would sugges there is an issue around the revenue target value field

I'm lost

[Qrishna]

Post some sample data.

[#3]

getting the same results. Only the records with no historical data

[#4]

Hi,

thanks for getting in touch.

What data do you want and how do I get I to you

[Qrishna]

you put some sample data i an qvw with your expression and logic and atatch it.

[#6]

please excuse my ignorance but I don't know how to do that