Using the sum function - narrowed down

[Anonymous]

Hi,

So I am using the sum function in a chart, as an expression, to add the original amount of loans all together. The problem I'm having is that the function is adding all the original amounts for every production date for every loan. So the number is much greater than it should be. Is there a way I can specify the function so that the original amount is only counted on a specific production date?

Thanks

[israrkhan]

share your sample document.

what are your dimension and expressions???

[#3]

Have you tried using any set analysis?   If you narrowed down the sum to only include the min(date) that could solve your problem

[#4]

What are the names of the fields you have involved?

[Anonymous]

prod_dt is what i want to narrow down by, orig_amt is what I want to sum together, and I'm limiting it to a certain loan type using the variable PresentLoanType

if(PresentLoanType <> 'Serviced for others', sum(orig_amt), )

This is the if statement I am using as the expression in the chart, but like I said the function is counting the orig_amt for every prod_dt when I just want it from one prod_dt

[#6]

Try

sum({<PresentLoanType -= {'Serviced for others'}, prod_dt = {'$(=date(min(prod_dt)))'}>}orig_amt)

[Anonymous]

This set analysis just changes all the amounts to zero