Hello, i am bringing a couple of simialr files to geehr but in one area thy differ crucicially; one file shows the line item age as an number, whilst the other file shows the aged of the line item by placing it within one the age bucket columns.
how can i bring the files togther so that the single column age is represented in the appropriate existing bucket columns?
CURRENT INPUT | |||||||
AGE | <1day | <2days | 3-5days | 6-10days | 11-15days | >115days | |
Line item 1 | 10 | ||||||
Line Item 2 | 1 | ||||||
ENDEAVOUR | |||||||
AGE | <1day | <2days | 3-5days | 6-10days | 11-15days | >115days | |
Line item 1 | 10 | 1 | |||||
Line Item 2 | 1 |
Solved! Go to Solution.
Hi @Dark5tar
Here is how you can do it. Create formula for each and flag the value.
Workflow:
Hope this helps : )
think i was over thinking it - perfect thanks
Happy to help : ) @Dark5tar
Cheers and have a nice day!