Weird math

[bpavuk]

What happened?

If you try to render this:

### Mission 1: Long Day in Dunwall
- Target: (m1target:: `= 894`) coins
- Collected: (m1collected:: `= 791`) coins
- Subt. debt: [m1debt:: `= number(this.m1target)-number(this.m1collected)`] coins
- `= number(this.m1debt)`

...the last line will say 1 instead of 103, and this flips up a lot of calculations.

DQL

No response

JS

No response

Dataview Version

0.5.67

Obsidian Version

1.7.7

Device

Samsung Galaxy Note 8

OS

Android 9

[holroy]

As I just explained in #2509 when you do inline queries in connection with inline fields, it's the query which is stored not the resulting value of that query. When you in addition re-use values from other non-evaluated queries you are asking for problems.

You are not guaranteed any order of execution, and as such you can't rely on a field with a query being evaluated before or after another query. It's pure luck/coincidence.

A safer way to do something similar would be to assign values to a list of cost, and then present it as `=sum(this.cost)` somewhere in your note.

[bpavuk]

Which means I need to find another solution for in-game bookkeeping