Hi,
I have a barchart diagram with just one dimension (month), but three different formulas:
- Projection (till year's end) based on the as-is figures
- Projection (till year's end) based on the official budget figures
- Projection (till year's end) based on a management target-line
The projection works like this: There is a fixed target-line per day and I have calculated a field Days_in_month (28, 30 or 31) .
- For the months in the future, I multiply that nr. of days with that amount and add the summed-up amounts YTD;
- For the current month, I multiply the nr. of remaining days with that amount and add the summed-up amounts YTD;
- For months in the past, I take 0 and add the summed-up amounts YTD.
I currently face the very strange issue that with the first and the third formula, all the months till December are displayed, but for the middle one only months Jan to June show up. There is no restriction in the dimension, all the months are there in that field and I cannot spot any difference between the formulas.
Is there anywhere else I could look for what causes that issue?
Thanks a lot!
Best regards,
DataNibbler
