I would like to display 'N/A' in the 'budget' column when i select a transactional level record
Attached is a trial QVW and data I was using to try and resolve a problem lining up Actuals recorded at transactional levels against a budget which is recorded at a balance/aggregate level.
Summary views are ok e.g.
Year Period Account Act Bud
2010 1 123400 120 100
2010 2 123400 115 100
Until you drill down to something more granular on the actual e.g. drill on a specific actual date e.g. 31/07/10
Year Period Account Act Bud
2010 1 123400 7 100
2010 2 123400 0 100
In this context the Budget is no longer valid. I have tried playing with the function GetFieldsSelection(Fieldname) to check whether the current drilldown is on a field which is beyond the granularity of the Budget and if it is set budget to N/A. Unfortunately you have to nest a lot of conditions covering all the fields you could drill down on which are not Budget fields.
(See the Summary Table on Sheet1 tab, expression rev_bud)
My next port of call was to conditionally suspend the column in the presentation tab of the properties but couldn’t get it to work and you still need the nested conditions.
Any thoughts would be great.
.png "Former Employee"){kind=icon}
