Property Control to hide $0 variances in crosstable

I am trying to create a property control that will allow the user to include/exclude $0 Variance in a cross table.

I have tried creating the property control using either an integer or a drop-down and then using them to create a rule in the Show/Hide, but I haven’t got that to work.

I did get the i.VarianceFilter to work when I used it to create a property control that allows the user to put in a value and filter out values under an inputted value, but I can’t figure out how to limit it to just $0 values

Here’s the details of that:

 

Since I couldn’t figure out the property control, I decided to simply create a rule and just hide the $0 variance from the user ( i.e. they don’t control it).

When I tested it, it did not hide all the $0

 

Before the rule

After the rule

The only row that was hidden was 655210-Field Line Oper. & Repair.  It did not hide the other $0.

Here is how Variance is found and it is formatted as currency.

I’m stuck on what to try next because I don’t understand why the $0 values are not being hidden as expected when I just use a simple rule.

Any help would be appreciated.  I'm holding off on uploading the .dxp at this time since it has financal info in.

(2) Answers

Login