I have a table report that has columns showing Period Budget, YTD Budget, Period Actual, YTD Actual for a cost centre. My issue is that a Period and YTD Actual is only returned if there is a budget figure present. Obviously I'm missing something but have no idea what! Any help would be appreciated.
I think you need to check the fields used inside these formulas, When you are saying Budget figure is not present, that means some of the fields used in budget figures are off and same are used in other two which might be impacting the Period and YTD actual, I can see common fields in the Budget and other two formuals.