Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to hide a row in one of my list boxes. The list box is my table Scenario, where I have "Budget 1" "Budget 2" "Budget 3" and "Current budget". The last one will always represent Budget 1, 2 or 3. Having a current budget makes it a whole lot easier when creating static tables, however it does make it (only slightly) confusing as there are two rows that represent the same data. So my question is, is it possible to hide this row?
What is the name of this Field? Is it Scenario or Scenario_ID?
If it is Scenario then use :
=IF(Scenario <> 'Current budget', Scenario)
If it is Scenario_ID then use :
=IF(Scenario_ID <> 'Current budget', Scenario_ID)
Can you post the QV document? or the screenshot?
Thanks for your help! I now figured out what i had done wrong. I had chosen field Scenario and in addition written an expression instead of chosing expression as a field.... Me being a bit slow
Thanks again
You are welcome! I am glad you have got it working.
Cheers - DV