Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What I would suggest is to troubleshoot your formula create a simple table and add three measures, your est and act fields plus your equation then your dimension data should be what you are grouping on. this will give you visibility of where in your data you have issue.
What I would suggest is to troubleshoot your formula create a simple table and add three measures, your est and act fields plus your equation then your dimension data should be what you are grouping on. this will give you visibility of where in your data you have issue.
If you want to calculate with the day-number you will need to grab this number and not formatting a date or even a timestamp to the visual day because the real value of it will be remain a date or a timestamp. This meant you will probably need something like this:
= (day([Act_TimetoComplete])-day([Est_TimetoComplete])) / day([Act_TimetoComplete])
- Marcus