-
1. Re: Help with calculation please
Vera Suponeva Oct 2, 2018 3:36 AM (in response to Imran Azam)Hi Imran,
I think, that is what you are looking for.
The main problem you had - calculated field wasn't recognizing fiscal year configuration. You need to put the logic into calculation. Below is the screen how to do it straight forward.
Also, find workbook with calculation attached.
Please, let me know, if you have any questions.
Thanks,
Vera
-
exampleVS.twbx 47.6 KB
-
-
2. Re: Help with calculation please
Imran Azam Oct 2, 2018 4:24 AM (in response to Vera Suponeva)Thank you for your reply, did you attach the worksheet?
-
3. Re: Help with calculation please
Imran Azam Oct 2, 2018 4:26 AM (in response to Vera Suponeva)this looks correct can you please explain how you did this?
-
4. Re: Help with calculation please
Vera Suponeva Oct 2, 2018 4:50 AM (in response to Imran Azam)Hi,
Please check out printscreen and worksheet attached in original answer.
I've created additional calculated field startdatemin with logic similar to endatemax.
Other changes were made in "status" calculation. before making the comparison, By nesting a DATEADD within a DATEPART, calculate the fiscal year for any date by first subtracting three months from the date in question.
Thanks,
Vera.
-
5. Re: Help with calculation please
Imran Azam Oct 2, 2018 5:17 AM (in response to Vera Suponeva)HI this works bit when i add other data in ( as this was just a small example it doesnt full work
if you have something like an email i can email you the whole thing
thanks for your help
-
6. Re: Help with calculation please
Vera Suponeva Oct 2, 2018 5:23 AM (in response to Imran Azam)Imran,
Mail me to vera.suponeva@gmail.com, please.
-
7. Re: Help with calculation please
Imran Azam Oct 2, 2018 5:52 AM (in response to Vera Suponeva)thank you