0

# Getting Ninox to Recognise a number

Hi All,

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?

3replies Oldest first
• Oldest first
• Popular
• John Halls
• John_Halls
• 5 mths ago
• Reported - view

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'))``

Regards John

Like
• 5 mths ago
• Reported - view

John Halls

I tried both

let 'Date of Tour' := 'Tour Date';
first((select 'Snorkel / Sea Scooter Tours')[Date = 'Date of Tour'].number('10am Snorkel AVAILABLE Spaces'))

and

let 'Date of Tour' := 'Tour Date';
number(first((select 'Snorkel / Sea Scooter Tours')[Date = 'Date of Tour'].'10am Snorkel AVAILABLE Spaces'))

No errors in the code but also nothing showing as a result.

I have currently resulted in going the long way round and basically writing the formulae that matches the one from that field i.e

it is created from a number field i fill out i.e 10 and taking away another field that has calculated a total number.

sum((select 'Snorkel / Sea Scooter Tours')[Date = 'Date of tour'].'10am Max Snorkelers') - sum((select 'Snorkel/Sea Scooter Guests')[Tour = 1 and 'Tour Date' = 'Date of tour'].Adults) + sum((select 'Snorkel/Sea Scooter Guests')[Tour = 1 and 'Tour Date' = 'Date of tour'].'Kids (Under 12)')

its long way round but seems to do the trick

Like
• Fred
• Fred
• 5 mths ago
• Reported - view

what do you mean you can’t use it in other calculations?

what happens when you do?

Like
Like Follow
• 5 mths agoLast active
• 3Replies
• 25Views
• 3 Following