Getting Ninox to Recognise a number
Hope this is a basic problem.
I have got a formulae that field that just needs to show what is in another table from another formulae field.
the current code is :
first((select 'Snorkel / Sea Scooter Tours')[Date = 'Date of Tour'].'10am Snorkel AVAILABLE Spaces')
it is showing the current number, however, Ninox now no longer recognises this value as a number so i am unable to use it for any calculations. is there a simple fix for the formulae to show it as a 'number' field?
Use the number() function. Either wrap it around the formula for the '10am Snorkel AVAILABLE Spaces' field or the whole of your line
number(first((select 'Snorkel / Sea Scooter Tours')[Date = 'Date of Tour'].'10am Snorkel AVAILABLE Spaces'))
what do you mean you can’t use it in other calculations?
what happens when you do?
- 11 mths agoLast active
- 3 Following