0

formula error! Format issue with formula!

I have a $$ field and when I use it in a formula, the field stay undefined...

sum(total_vente, prix_shipping, taxes)

each field in the sum are $$ format... I tried : sum(number(total_vente), number(prix_shipping), number(taxes))

but same issue!

Is there someone with an idea ? Thanks!

7 replies

null
    • plafontaine44
    • 4 yrs ago
    • Reported - view

    I made some test and each time the field is a formula field, it stay undefined... it must be a number field or other format... Sound weird...why we could not take formula field in equation ?

    • Mconneen
    • 4 yrs ago
    • Reported - view

    What version of Ninox?  Mac App, iPad, iOS, Web Browser ?   Works on the Mac app and Browser .. 

    formula

    • plafontaine44
    • 4 yrs ago
    • Reported - view

    web browser... 

    Its like: field A = number + number 2

                field B = field A + number

    it s like the field B wont take the formula because it s formula sources... It s still undefined... How can I correct it?

    • plafontaine44
    • 4 yrs ago
    • Reported - view

    I made it work but it s incredibly slow and I have a good connection...

    but that was just a test field...here the real one...it s a pop-up

    let a := concat("Montant donné diffère du montant de la facture de: ", abs(sum(number(Montant), number(Montant_2), number(Montant_3)) - sum(total_vente, prix_shipping, taxes)));
    if abs(sum(number(Montant), number(Montant_2), number(Montant_3)) - sum(total_vente, prix_shipping, taxes)) > 0.01 then
    alert(a)
    end

     

    it have works for a time but now it wont...but I lost some field...some other wont refresh...my 'show only if' formula comes to issue too...

    something seem to be wrong with the connection I think...

    • plafontaine44
    • 4 yrs ago
    • Reported - view

    is there a way to check connection quality? I lost all data from my table...it start spinning and sometimes I have to quit and come back to finaly load data...and after few minutes if I change table it start spinning again...and data desapear...

    my connection here is gigabite and every other site works well... What can i do?

    • plafontaine44
    • 4 yrs ago
    • Reported - view

    DB Hope the picture would be fine...but that wath I experiment since few days...my formula wont update and data desapear... any ideas??

    • Birger_H
    • 4 yrs ago
    • Reported - view

    Please contact support@ninoxdb.de

    Birger

Content aside

  • 4 yrs agoLast active
  • 7Replies
  • 1846Views