I am trying to write a PCR where Total Amount should be divided by Number of Splits available.
For Eg - Split 1 shows value 5000.
Split 2 shows value 5000.
Split 3 shows value 5000.
I want Total value, i.e 15000 to be divided by no. of splits , i.e 3. So that end Results comes Amount 5000.
I Tried many ways but not able to meet the result.
Your help will be much appreciated.