Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
After some more advice!
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.
My columns are as follows
Period Budget
AGGR(NODISTINCT
sum({<BL_ACTUAL_FLAG={'B'}>}BL_PERIOD_NET_DR-BL_PERIOD_NET_CR,PERIOD_NAME, COST_CENTRE, SUBJECTIVE, DETAIL)
YTD Budget
AGGR(NODISTINCT
SUM({<BL_ACTUAL_FLAG={'B'}, forecastflag-={'F'}>}BL_BEGIN_BALANCE_DR-BL_BEGIN_BALANCE_CR+BL_PERIOD_NET_DR-BL_PERIOD_NET_CR)
,PERIOD_NAME, COST_CENTRE, SUBJECTIVE, DETAIL)
Period Actual
AGGR(NODISTINCT
sum({<BL_ACTUAL_FLAG={'A'}, BUDGET_NAME=>}BL_PERIOD_NET_DR-BL_PERIOD_NET_CR)
,PERIOD_NAME, COST_CENTRE, SUBJECTIVE, DETAIL)
YTD Actual
GGR(NODISTINCT
SUM({<BL_ACTUAL_FLAG={'A'}, BUDGET_NAME=>}BL_BEGIN_BALANCE_DR-BL_BEGIN_BALANCE_CR+BL_PERIOD_NET_DR-BL_PERIOD_NET_CR)
,PERIOD_NAME, COST_CENTRE, SUBJECTIVE, DETAIL)
Thanks
Diane
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.
I think it's that there is no figure present in the budget qvd for that code. I need the actual to display regardless of whether there is a budget. My actual measure is as follows:
AGGR(NODISTINCT
sum({<BL_ACTUAL_FLAG={'A'}, BUDGET_NAME=>}BL_PERIOD_NET_DR-BL_PERIOD_NET_CR)
,PERIOD_NAME, COST_CENTRE, SUBJECTIVE, DETAIL)
and budget
AGGR(NODISTINCT
sum({<BL_ACTUAL_FLAG={'B'}>}BL_PERIOD_NET_DR-BL_PERIOD_NET_CR)
,PERIOD_NAME, COST_CENTRE, SUBJECTIVE, DETAIL)
Any help appreciated.
thanks