Calculating return, via Parameter

[mike02]

Hey,



I have my query set up, and the return calc is running smoothly, however I want the first value to come back as 0, since you cannot have a return on a 0 Value....

Now, Here is my Set Up:

ClientID....ProductID....InvestmentID...MonthlyDat e..Start...Cash...end....Expr...Return....(Where expr equals REturn calc...)

Now I want to set up an if statment saying IIF( MonthlyDate=Min(MonthlyDate) Where InvestmentID=InvestmentID And ClientID=ClientID And ProdcutID=ProductID,"0",expr)

Thanks,

[June7]

Don't understand the criteria in that condition.

What field is used to calculate return - Cash? What is the Return calc result if Cash is 0? Why would the calc not be 0?

[mike02]

The return is the (End/Starting Asset) -1

The starting asset is the previous End, but if the End is Null, Meaning first month, then it is the initial transfer.

So it will never be zero....

Now If i can put a where condition on it, then i will be able to get around this issue, If it is the Min(MonthlyDate), which is the first Month the client started

[June7]

Post query for analysis and sample of data might be helpful. If you want to provide db, follow instructions at bottom of my post.