formula with no values

[ddebnath]

Hi,

I made a formula like this:

If ({T21Budgets.WIN} = {T22BdgtRev.WIN} Then
Sum({T22BdgtRev.Amount}, {T21Budgets.year})

There is no syntax error, but when I insert the formula in the report, it doesn't give me any value. Actually, in browse field data, I don't see any values. I don't know what's wrong. Anyone have any idea?

Thanks

Dip

 

[dcm]

Dip: Try displaying T21Budgets.WIN, T22BdgRev.WIN on a details line and suppressing the line if the 2 fields are NOT equal - this will then display only those ocassions when they are and from here you should be able to determine what else you need to do. Also I assume you have grouped by T21Budgets.year otherwise you will get an error when checking the formula David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[Thanks]

David,
Thanks, I figured out what's wrong. Now it works
Thanks again

Dip