Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning
Hope all are well.
I have a loaded table that has the following elements:
Account Month Balance
123456 Oct 26000
123456 Nov 28000
123456 Dec 28500
123456 Jan 25000
122244 Oct 27500
123321 Jan 10000
123321 Oct 12000
I have a straight table and I only want to pull rows where an account has a row in each month (Oct,Nov,Dec,Jan) and has a balance greater than 25000 in each month.
In the example above, these would be the only rows pulled:
123456 Oct 26000
123456 Nov 28000
123456 Dec 28500
123456 Jan 25000
Thank you
Thank you that helped except the text has been converted to exponential text format.
How can I convert so I show all 18 characters.
Thanks again
Perhaps using the Dual function. Dual(Text(MyNumber), MyNumber) as MyNumber
Thank you but still showing as exponential text