Forum Discussion
How Create the calculated Colum to identify Part-payment
Anonymous
I am still not very clear about this logic. However, i can get the expected output. I am not sure if this solution works for your real data or not. please let me know if anything else need to be modified.
Hi ryan_mayu,
This is just sample data let me try to explain with example
Based on sample data
Current financial year FY 22 –Q1 to FY22 –Q2
Previous financial year FY-21 Q1 to FY-21 Q4
current financial year last quarter : FY-22 Q1
Example This ref order “NK/19-20/099246” we need to check in FY-21 Q1 to FY-22 Q1 if ref order found between this data range than is should be mark as “Partpayment”
Refer sample data desired results fields this “NK/19-20/099246” exists in “FY-21 Q1” and FY-21 Q3 hence I mentioned Partpayment
This means refer order created earlier now we are getting Part-payment
I hope this help to understand my question
Anonymous
I am still not very clear about this logic. However, i can get the expected output. I am not sure if this solution works for your real data or not. please let me know if anything else need to be modified.