how to calculate a boolean based on data from a table fed by a BI Query
I am currently struggling with the following issue:
- I have a query in my VC model wich returns 4 ratios
- I put the result of the query in a table in the VC model
- then, I added a column in the table. this column is a boolean which should be true if the value of one of my 4 ratios is not 0, otherwise, it is false
- I want that boolean to be "updatable" by the users.
I tried to define the default value of the boolean based on the value from the signficant ratio... no luck
I tried to change the value from the configuration tab of the column, but then I can not update afterwards....
Has anyone ever seen that issue and found a solution ?
Thansk for your help