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?
-
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
-
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
-
-
what do you mean you can’t use it in other calculations?
what happens when you do?