Math in Tables – what am I missing?

Tagged: 

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #23652

    Becca37
    Participant

    Sorry, I’d search the forums, but I don’t see a search option!

    These are not giving me values expected (yes, saved the table and viewed it on site, I have an image https://pigasus.studio/files/exteralsamples/SubsysticDatatablesMathWoes.png)

    Multiplication: =D4*E4 and =D5*E5 — on site each value shows $0.00; F4 should be $44.70 and F5 should be $3.00

    Sum: =SUM(F4:F19) — on site it shows $0.00, which could actually be working since the individual values are showing as $0.00 sum of same is indeed $0.00, but I don’t really know if it’s working or not since the multiplication values are not calculating properly; sum should be $47.70

    #23653

    Becca37
    Participant

    Image link correction: “p” not “b”!

    https://pigasus.studio/files/exteralsamples/SupsysticDatatablesMathWoes.png

    #23654

    Becca37
    Participant

    Nevermind, I don’t know what I’m doing differently ’cause the formulas look exactly the same, but after some accidental column sorting in the backend and rebuilding (’cause I didn’t see the sort for a bit) many of my cells, it’s working. :0)

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.