1 of 1 people found this helpful
if [Budget]>=[Actual] then [Budget] else [Actual] end
should do it. You may want to check for Nulls in the data, so:
if zn([Budget])>=zn([Actual]) then [Budget] else [Actual] end
this may help
I tried this but the problem I have is in my real data underneath the budget and actual lines are account codes which individually have their own budgets and actuals and not all actuals are positive some can be negative (to show a credit for instance).
What I think I need is a way to say actuals from April to May and Budget from June to March.
Would need to see how your data is actually structured then if it's different from the example you gave
Given the data in this file, can you show exactly the result you want?