AnsweredAssumed Answered

Total Column appearing when it shouldn't

Question asked by bbroughton on Apr 8, 2019
Latest reply on Apr 9, 2019 by bbroughton

I've just encountered an issue in a dataview where the total column appears even though 'row totals' is un-selected on the block (appearing in 10.3 and 10.5)

 

The ORANGE column below should not be appearing.  The cube/block it relates to is dimensioned by an entity called 'Column Header Hours', and the block is set to data entry and 'detail by' this Column Header Hours entity.

 

A capsule procedure triggered by a pager on the screen then uses a mapping cube to select members from this entity based on a mapping cube.  This is to control what DataEntry the end user has available based on the paged report.

 

Depending on the pager 'selection' some times there will be 0 members of the 'Column Header Hours' entity selected.  Doing this as a dynamic screen select doesn't work, as BOARD will select ALL members of the entity where the mapping cube is empty (which is the opposite of what is required).

 

So we tried to use a trigger procedure.

 

However even though no members of the Column Heading Hours entity are selected, and none are showing, BOARD still displays the 'TOTAL' column.  If a member of Column Header Hours is selected the Total column doesn't show, and only the column for the selected member shows.

 

It seems like a bit of a bug to me, but just wondering if anyone else has come across this and found a way around this issue?

 

With 0 members mapped the 'TOTAL' column shows

 

with 'Labour Hours' mapped - no 'TOTAL' column showing.

Outcomes