Division Formula [Apr 27]

Discord-Discussions
1

:raising_hand_man: Evasty’s asked

hi i can’t seem to get a formula with a division “/” to show a result, and am not sure what i might be doing wrong, any help appreciated.

(also tried with number type, it’s a sample project w internal db)

formula column is: (cost / days)

image0
image0976×128 5.45 KB

2

:raising_hand_man: wkw replied

Im using number types with your formula and it looks fine

image0

3

:raising_hand_man: wkw replied

please create an issue in github with details

4

:raising_hand_man: Evasty’s replied

ty, i did, not sure if it’ll show as github flagged my acc as soon as it was made so i’ll link it here:

Formula columns on heroku not showing results. · Issue #1868 · nocodb/nocodb · GitHub

5

:raising_hand_man: wkw replied

i couldnt access this link

6

:raising_hand_man: Evasty’s replied

hope you don’t mind me copying the issue here as i haven’t been able to solve the account flag issue:

Node: v12.22.12

Arch: x64

Platform: linux

Docker: false

Database: pg

ProjectOnRootDB: true

RootDB: pg

PackageVersion: 0.90.7```

Steps To Reproduce

1. Host on heroku with 1 click free deploy button (everything as is) and create a new project with internal db.

2. Add a table, add 2 number columns (cost, days), and any number of formula columns which use the number columns.

3. Add rows

4. The formula columns fail to show any result and there’re no error reports.

Expected Behavior

The formula columns to be filled or an error notification.

Screenshots

image
image1359×123 7.15 KB

formulas are respectively:

“MAX(cost, days)” , “cost” and “(cost / days)”.

also noted that when downloading the sheet as csv all values are filled correctly.

refreshing/reloading does nothing.

(view of sample sheet: https://testlvl2nocodb.herokuapp.com/dashboard/#/nc/view/dc4cb9be-110e-4856-9d34-211bb78645f5 )

7

:raising_hand_man: wkw replied

lemme help create the issue for u

8

:raising_hand_man: Evasty’s replied

that’s even better, thank you.

if there’s anything that might help please let me know.

9

:raising_hand_man: wkw replied

sure. created here - PG Formula issue · Issue #1873 · nocodb/nocodb · GitHub

10

:raising_hand_man: Evasty’s replied

ty vm n.n!

11

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs