Thanks for the update. I checked it again and basically what I was doing was running a query on something that already had that field in it so it just...
Yippee! Mynda rides to the rescue again ! woo-hoo. Thanks a mil.
It's really weird. It's a US CSV file which I pulled straight into PQ. in the data set itself (in Excel - where the local format is dd/mm/yyyy) the "o...
Thanks - got there eventually by the very very scenic route 🙂 Of course now I'm looking at it and thinking I should have done most of the formulas i...
Got it all working without the use of a calendar table after all. Lashed in the parameter query into the formulas and it works much much more quickly ...
No, there's a method there in the deferred income - got all those formulas working. 🙂 Totally understand why it would bug you. Went out for long wal...
The subscription deferred references a vlookup that says if it's X subscription, then it's 0 deferred i.e. the day the invoice was sent was the day th...
hi Mynda Thanks for this. I'm attaching a sample file - it doesn't have all the calculations that I currently have (e.g nothing for partially defer...
Brilliant - thanks a mil. Is it wrong to say I love you and want to have your Excel babies 🙂 in a MMMMM sort of way 🙂
Went back again and figured it out 🙂 Thank you.