subzwari

Running total every 5 days

I want to sum expanse Sunday to Friday in work week expanse field and ignore Saturday to Sunday I can only sum per week by using week function can’t sum 5 days.

• Answered

google chart in form

I am trying to insert google chart in a form what is the code

• Answered

I want add 3 months future date with click of button.

code attached to the button is let YR := year(Date);let MO := month(Date);let DY := day(Date);let DT := date(YR, MO + 1, DY);for i from 0 to 3 dolet j := (create Register);j.…

Need help with converting FileMaker formula to Ninox

13.12+(.6215*g_Main_temp)-(11.37*g_Main_Wind ^ .16)+(.3965*g_Main_temp*g_Main_Wind ^ .16)

go to a table view (instead of dashboard) when opening database

I am trying to write a global function to open a table view when I open the database. openTable("Table name","View name") does not work.

Formula giving invalid result

I have a related table and on the parant table form I want to find the average of records from the related table. the formula I am entering is let x := Id;sum((select Synoptic where Id = x).…

Switch statement evaluating to default value

switch 'FL Value' docase 'FL Value' > 48.3389 and 'FL Value' < 57.7777:text("A")case 'FL Value' > 40.0056 and 'FL Value' < 48.3388:text("B")case 'FL Value' > 32.7833 and 'FL Value' < 40.…

formula giving error

Hi, I am trying to enter the following formula (6.112*10 ^ (7.5*temp/(237.7+temp))*Humidity/100) Where temp and Humidity are numeric fields. It is giving me an error that symbol expected:…