If condition is giving wrong values

[alec1982]

Hi guys,

Can anybody figure out what's wrong with this If statement! it is giving value of 180 instead of 77!!

if (

    Sum(    if ( ((Index([Expense Type (annual)], 'Rent') = 0) or GetFieldSelections(_ShowRentFlag)=1)

                and ([Year of Expense] = $(varPlReportingYear))

              ,[Amount of Expense (USD-annual)]

            ))

         > 0

    ,

        Sum(if ( ((Index([Expense Type (annual)], 'Rent') = 0) or GetFieldSelections(_ShowRentFlag)=1)

                and ([Year of Expense] = $(varPlReportingYear))

            , [Amount of Expense (USD-annual)]

            )

        ) / 1000

    )

I appreciate any help.

Thxs,

Alec

[Jason_Michaelides]

I think you'll need to post your app to get such specific help! However, I can't see a second part of the If statement...what if the evaluation condition is not true? (I'm on a train and may have misread it...)