11 Replies Latest reply: Feb 5, 2016 6:33 AM by Sai Manogna Nallamothu

# To find out the emi paid till the selected month

Hi,

In my scenario,there was two types of payments,cash and emi.Could anyone suggest me the expression to find out the amount paid by the customer till the selected month.I have every monthly_payment for every customer who has taken EMI.

Thank you.

• ###### Re: To find out the emi paid till the selected month

=SUM({<

Year = {"\$(=Max(Year))"},

Month ={'\$(=Month(MakeDate(Max(Year), Max({<Year = {"\$(=Max(Year))"}>}Month))))'}

>}Amount)

• ###### Re: To find out the emi paid till the selected month

Hi Manish,

Actually in my fact table i have like JAN-Monthly Payment-10000,Feb Monthly Payment -10000,march Monthly Payment -10000 for every month.

So Actually what i thought is that suppose now if i select Feb it should show that the amount paid is 20,000

But If i try the above expression it was showing 10,000 .Could you suggest any change in the expression so that i could get the sum of the amount paid till that month

• ###### Re: To find out the emi paid till the selected month

Try this..

=SUM({<

Year = {"\$(=Max(Year))"},

Month ={'<=\$(=Month(MakeDate(Max(Year), Max({<Year = {"\$(=Max(Year))"}>}Month))))'}

>}Amount)

• ###### Re: To find out the emi paid till the selected month

Which fields you have from below mentioned fields?

Date,

Month,

Year,

MonthYear,

YearMonth

• ###### Re: To find out the emi paid till the selected month

Date,month,year,monthyear,

• ###### Re: To find out the emi paid till the selected month

Have you tried 2nd formula given in my previous post?

Can you provide sampled app?

• ###### Re: To find out the emi paid till the selected month

Yes Manish I have tried it it is showing 0

Above is the enclosed image if i click on the Customer_ID 2013,Actually the payment type is EMI_12 .The customer has paid for every month .So my requirement is that If i click on the Apr it should add all the months between the selected and the Order_Date.

• ###### Re: To find out the emi paid till the selected month

Kindly provide sample application or excel file having few lines similar to your application.