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
  • Newest first
  • Active threads
  • Popular
    • John Halls
    • John_Halls
    • 4 days 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
      • Admin
      • Admin.11
      • 4 days 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
    • 4 days ago
    • Reported - view

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

    what happens when you do?

    Like
Like Follow
  • 4 days agoLast active
  • 3Replies
  • 24Views
  • 3 Following