Hi,
I have created an entity which has part data in it. I want to do a calculated field for total price, which is simply [Qtyinstock] * [cost]
When I first set this up it worked fine. I created the calculated field ok.
Then I realised I had defined the wrong data type for quantity, as I could change it I created a new field called [Quantity in Stock] and put the data in that field. When I try to change the calculated field the new field doesn't appear. If I type in the field name it fails validation.
I have tried deleting the total field and recreating it, and deleting the old qty filed. the old field disappears from the list so I know the list is updating
Any thoughts?
Troy