Hi all,
I have a table that I use for daily money inflow and outflow amounts. I want to add a flag indicating whether the money received is released on the same day or 1 day later. The rule for flag is that if up to 90% of the incoming money is out, the flag should be 1, otherwise it is 0.
My columns in the table are as follows: Date, In/Out, Customer, Amount
how can I do it? I would like to use set analysis if possible. thanks for the help