There is both a logical error as well as a naked field* (bold) in this expression. The logic should be as Marcus outlined above, but that does not solve the naked field. It is not clear what you want to with the total for this expression.
But that looks logically wrong as well - you are subtracting a number of days from a value (LOAN_AMOUNT * RATE), which does not look correct - do you not mean to divide?
*Naked field is a reference to a field not inside an aggregation function like Sum(), Count(), Max() etc. This field will only return a value if there is only one possible value at that point - which is not true for the totals.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I want to calculate the loan interest for the number of days between today and the Started day(DATE). Rate should be divided from 22.54 to achieve the daily basis interest rate.
In this simple logic available to calculate
If( Status= 'ACTIVE',
If above logic is true,
1. loan_amount*Daily Rate* no.of days,
Other wise,
2. (Installment* no. of installment)-loan_amount.
The problem is no.of days calculation is not working with the logic as i understood. As i have tested the same without logic it is working as expected.
I think the problem is that DATE isn't unique defined and you need something like:
NUM(TODAY()-max(DATE))
which then needs to be wrapped with an aggr because it would be inside from the sum-function (no nested aggregation without an aggr-function) whereby it might be easier to outsource these calculation into a variable.
