Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, Guys
I am working on a rather interesting solution, on which i would like to see some input from the Pros
In the load script i have used the following expression, because I thought that I have some symbols after the coma
Round(sum, 0.001) as delay_sum
Round(sum, 0.001) as paid_sum_res
On some of the ID's that I am going through the formula evaluates correctly, but for 3% of the dataset it doesn't evaluate if column1=column2 correctly, like in the case of the screenshot.
How Can i format the numbers, or the expressions to get the true value when I compare these columns?
paid sum res is the payment amount, but with different types(type_res).
Delay_sum is the delay_interest assigned to each UNIQUE ID.
I want to get the following logic
sum(If(sum(delay_sum)<=Sum({$<type_res={'delay_interest'}>} paid_sum_res,delay_sum))
Basically i want to check if the payment for this specific type is done, and if it is take the delay_sum.