Forum Discussion
filtered data showing wrong result
Hi Mathur! thank you again for your help on this. I went back and check the data again and the query used to pull the data was not correct. You are correct that it is 34. I should have looked a litle closer at that.
Everything is working fine now.
Thank you so much again
Hi,
My thought is to split each row into one row for each month between the start date and the earlier of (Termination date or End date). This will lead to a number of rows being generated. If you are amenable to my approach then i can try to implement it. Let me know.
Yes, please feel free to try your approach. I would though it would be pretty simple. I guess not. Thank you so much for your prompt response.
The answer should be 34 (not 40). Please find attached my solution file.
Hope this helps.
Hi Mathur! thank you again for your help on this. I went back and check the data again and the query used to pull the data was not correct. You are correct that it is 34. I should have looked a litle closer at that.
Everything is working fine now.
Thank you so much again
You are welcome.