Need help!!!
Attached excel file for your reference.
1. Based" no of days" pending need to lookup or fill (formula) ageing status.
2. Based on status count no of ageing and distinct nonid .
Yes i want like that. However count of ageing mismatch is there. Example below
Negative more than 180 is actually 1 only, If i use helper column it will become 2 only. I need help on this.
Negative More than 180
3
Second,
Ageing status you have derived lookup formula with concatenation. If negative , negative & 30 day you have used.
Many other report we are not using same template for example data will be like this.
so we cannot use concatenation formula. Example below
Some reports we have status like "new status" so we cannot use concat. Kindly help on this.