Formula based on hidden field
I have a dataset with two fields (invoice quantity and invoice amount) and a formula based on the quantity.
I want only to display in the grid the formula and the amount, o I set VisibleInData to false on the quantity fields, but doing so seems to remove the field values from the slice, and my formula always evaluate to zero (unassigned). If I set VisibleInData to true it works beautifully.
Is there any other way to hide non-wanted fields?
Thanks
I want only to display in the grid the formula and the amount, o I set VisibleInData to false on the quantity fields, but doing so seems to remove the field values from the slice, and my formula always evaluate to zero (unassigned). If I set VisibleInData to true it works beautifully.
Is there any other way to hide non-wanted fields?
Thanks