-
How to Calculate Cumulative Sum
I have this info on my Table COST_W, I have the Week, the Cost by Week, but I need a Formula for calculate the Cumulative Sum. On the Table EV_Management is where I charge the Cost by Activitie and…
- Answered
-
Group Sum Cost by Week
@Fred Need to sum cost for the group of week on the EV_Management table I try this formula but don't work let Wk := Week; sum((select EV_Management)[Week = Wk].…
- Answered
-
Calculate integer from decimal value
Hello, For a calculation I need to know the integer part of a decimal value, ie. 34.25 would give me 34 as the integer part. I expected to see a trunc() (or similar) function in the Ninox logic set,…
- Answered
-
Time interval use and sum
Hi, there is something I don't seem to understand (odd, uh?) when use time interval fields. I want to define the daily working time and since it doesn't matter when job starts or ends,…
- Answered
-
Image size in fx field
IMAGES SIZE: I have a table, containing images, to be used as headers in other places of my database I have made the images to fit the size of the header space - a fx field : (select HEADERS).…
- Answered
-
SUM COST By CUTOFF_DATE
@Fred Hi Fred I hope help with that. On the EVM Table I have the KPI' Activities Form in that form have the Field Actual_Cost here I charge the accumulated cost Week by Week in each activitie (need…
- Answered
-
How to get a dynamic multi choice field to update
Hi all - I'm using the MacOS app. So I have this code in the Dynamic value section of a field called dMC2: let prevDMC := numbers(dMC); (select Table1)[(var t := this;…
- Answered
-
Concatanate - Two For loop -
let check := dialog(" ATENCION ", " ¿Confirma el SETUP de la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]); if check = "Si" then for loop1 in select BASELINE do 'Date:' := loop1.…
- Answered
-
Formula Problem
if Schedule_V < 1 then styled(" UNDER PLANNED COST ", "white", "warn") else if Schedule_V > 0 then styled(" OVER PLANNED COST ", "white", "ok") else if Schedule_V = Plan_V then styled(" GOOD ",…
- Answered
-
function between two numbers
hi everyone i have the following issue... I need to show a message following numeric rules. for example.. if number < 5 then "Result 1" if number > 10 then "result 3" but now,…
- Answered
-
Very slow opening table
I have a table with many many fields (about 55). The form associated with it performs okay, but opening the table itself takes almost a minute even though there are only 36 records so far.…
- Answered
-
all databases disappeard
I'm using Ninox Mac, with my databases in cloud. when I open Ninox, I get a complete empty window. when I look in mobile documents, databases are still there A suggestion? I'm a little bit desperate.…
- Answered
-
Can i hide empty fields in the customer view?
After starting this new DB in the middle of the year i have many customer items that do not have the full information in them so when looking at them it shows all blank fields when doing a ascending…
- Answered
-
Import csv files with related tables.
How's it going. I need a procedure to import csv files with related tables. There is something hidden somewhere.
- Answered
-
Jump
There are any way to jum from LT_Actividades to Disciplinas associated. When click the LT_Actividades Display all Activities link with all Disciplines, can I choose only the Display on DISCIPLINAS.…
- Answered
-
Why would a dashboard disappear after saving a dup DB?
I am to the point that i want to start loading in data into a clean working DB set up for my use. So did a dup of a working DB and gave it a new name. I now see the Dashboard is blank nothing is in…
- Answered
-
Take Date from another Table
I need to take a Date (FechaP1) in the ACTIVIDADES Table, from the DOCUMENTOS Table belonging to DISCIPLINAS. The Orange Date, I try with these formula but take always the same dates first((select…
- Answered
-
Weird issue with DB
Hi all - I'm still on v3.5.14 of the MacOS app. I'm waiting awhile before updating to 3.6. Can you duplicate the following issue? After opening the attached table, click on Invoices.…
- Answered
-
Problem with radio Botton on Web version
@Fred Hi Fred please can you check something.? On Table Documents the WBS on new Web version 3.6 Lost the radio button , no problem on previous version, on Android version is ok work perfect.…
- Answered
-
How to Duplicate a table also with a subtable
Just quickly created Table 1 and Copy Table 1 for example, I'm wondering duplicate Table 1(Table 1-1) to Copy Table 1(Copy Table 1-1), but only able to duplicate the main table's field,…
- Answered
-
Single user, multiple Macs
I'm interested in the standalone Mac version from the App Store for 35 euros, and store my data in iCloud to access from multiple Macs. I'm a single user,…
- Answered
-
2 questions about views
Hi, I was playing around with views and started wondering about a couple silly things: 1. When creating a nee table, the default table view is created.…
- Answered
-
Ninox for Mac vs Ninox Cloud
Hi, Do I need to subscribe if I only want to use Ninox on my mac?
- Answered
Answer questions and share your knowledge