compare two fields in a table box and show the higher value
Hallo everyone,
I have a table box, and I want to compare the field "value 1" to "value 2" and show either "method" with bad or "method" with good.
method
value 1
value 2
inputfield
bad
3
5
do something
good
4
2
The problem is I can't set any expressions in a table box and I need a table box for my inputfield. My Idea was to set a action with a button, but I don't know how.
Does anyone have an idea for comparing the two value fields and showing method field after all. Thx.
I know this is going to be an unsatisfying answer but this is how I handled a similar situation: I put a straight table chart with the appropriate dimensions and expressions on a tab and I put a table box on the lower part of the tab. Report users were instructed to use selections and the straight table to find the data that needed to be adjusted. Then they had to click on the expression cell in the straight table which would automatically select the dimension values for that row. After the selection is made, only the specific row that needs to be adjusted would be showing in the table box and the user can type in the adjustment and do the update.
Maybe it's the only way to get both inputfield and expressions in a table box. But it doesn't solve the entire problem I have. I want to show all the values with pushing a button. Has anyone any Idea? Thanks.
