Hi Morgaine,
now the formula was show in table only as text
thats are my formula
field formula
g4: (= ({{!!g2}}+{{!!g3}}) =)
h2: (= ({{!!g2}}*12/{{!!f2}}) =)
h3: (= ({{!!g3}}*12/{{!!f3}}) =)
h4: (= ({{!!g4}}*12/{{!!f3}}) =)
h5: (= ({{!!g5}}*12/{{!!f05}}) =)
h6: (= ({{!!h4}}+{{!!h5}}) =)
All formula are beginin at the first sign into the field
In all Formula are the ) the last sign.
Am Samstag, 29. Februar 2020 10:39:59 UTC+1 schrieb Morgaine O'Herne:
>
> I think I've spotted some reasons for the problem.
> 1. You have to have only the formula in the field, nothing else. If you
> want other words in the cell with the value of the formula, you need to
> write them in the cell, not in the field.
> 2. When you write the formula, there has to be a space between the (= =)
> and the formula itself, on both ends.
> As in (= {{!!field1}}+{{!!field2}} =)
> not (={{!!field1}}+{{!!field2}}=)
> Some of your formulas do not have this space.
>
> Hope that's all it takes to fix it. Let me know if you need any more
> help. 🤓
>
>
> Morgaine
>
> On Sat, Feb 29, 2020 at 2:20 AM Gerald Weis <[email protected]
> <javascript:>> wrote:
>
>> Hi Morgaine,
>>
>> i have new structured my tiddler:
>>
>> the new code is
>> <<Headline "Toyota C-HR Hybrid" "NK-WG-59">>
>>
>> |{{!!title}}|c
>> || A | B | C | D | E | F | G | H |h
>> |^ !1|{{!!a01}} |{{!!b01}} |{{!!c01}} |{{!!d01}} |{{!!e01}} |{{!!f01}}
>> |{{!!g01}} | {{!!h01}}|h
>> |^ !2|{{!!a02}} |{{!!b02}}| {{!!c02}} | {{!!d02}} | {{!!e02}} | {{!!f02}}
>> | {{!!g02}}| {{!!summe_h02}}|
>> |^ !3|{{!!a03}} |{{!!b03}}| {{!!c03}} | {{!!d03}} | {{!!e03}} | {{!!f03}}
>> | {{!!g03}}| {{!!summe_h03}}|
>> |^ !4||<|<|<|<| {{!!summe_f04}}|{{!!summe_g04}}| {{!!summe_h04}}|h
>> |^!5|{{!!a05}} |{{!!b05}} |||| {{!!f05}} | {{!!g05}}| {{!!summe_h05}}|
>> |^!6||||||| {{!!summe_g06}}| {{!!summe_h06}}|h
>>
>>
>> i follow your tip. But i have a problem.
>> i have create for each formula an new field.
>> Now it dont work:
>> fields Formulas and what the result in to images wich append.
>> I'm worry
>>
>>
>>
>> Am Samstag, 29. Februar 2020 07:39:40 UTC+1 schrieb Morgaine O'Herne:
>>>
>>> Hi Gerald,
>>> The eval formulas don't go in the fields. The eval macrocall in my
>>> example is in the tiddler itself.
>>> Here is an example of a formula that *can * be in a field:
>>> myfield: (= round(({{Eriel - Attributes!!agility}}+{{Eriel -
>>> Attributes!!dexterity}}+{{Eriel - Attributes!!strength}})/3) =)
>>>
>>> This calls in fields from other tiddlers like so:
>>> {{TiddlerName!!fieldName}}
>>> The value of the formula above can be called into another tiddler by
>>> referencing the field, as in {{tiddlerTitle!!myfield}}
>>>
>>> Another way to do this would be to use the eval macrocall in the cell of
>>> the tiddler, and target the field name, then reference that field name in
>>> another tiddler in the same way.
>>>
>>> I hope this helps.
>>>
>>> Don't feel bad; I spend a lllooooonnnnggg time studying all this before
>>> it started to make sense.
>>>
>>> On Fri, Feb 28, 2020 at 2:41 AM Gerald Weis <[email protected]> wrote:
>>>
>>>> Hi Morgaine
>>>>
>>>> thats the code of my tiddler
>>>>
>>>> <<Headline "Toyota C-HR Hybrid" "NK-WG-59">>
>>>>
>>>> |{{!!title}}|c
>>>> || A | B | C | D | E | F | G | H |h
>>>> |^ 1|{{!!a1}} |{{!!b1}} |{{!!c1}} |{{!!d1}} |{{!!e1}} |{{!!f1}}
>>>> |{{!!g1}} |{{!!h1}} |h
>>>> |^ !2|{{!!a2}} |{{!!b2}} | {{!!c2}} | {{!!d2}} | {{!!e2}} | {{!!f2}} |
>>>> {{!!g2}}| {{!!zwischensummen_h2}}|
>>>> |^ !3|{{!!a3}} |{{!!b3}} | {{!!c3}} | {{!!d3}} | {{!!e3}} | {{!!f3}} |
>>>> {{!!g3}}| {{!!zwischensummen_h3}}|
>>>> |^ !4|>|>|>|>|>| {{!!zwischensummen_f4}}| {{!!zwischensummen_g4}}|
>>>> {{!!zwischensummen_h4}}|h
>>>> |^ !5|{{!!a5}}|{{!!b5}}|||| {{!!f5}} | {{!!g5}}|
>>>> {{!!zwischensummen_h5}}|
>>>> |^ !6|>|>|>|>|>| {{!!summe_f6}}| {{!!summe_g6}}|{{!!summe_h6}}|h
>>>>
>>>> all Fields form A2 to G2 and
>>>> and A3 got G3
>>>> and A5 to G5
>>>> must all year new editet.
>>>>
>>>> the values you can see are testdata.
>>>>
>>>> 2 questions.
>>>>
>>>> 1. how can i the tiddler clone or of an other way copy that the fields
>>>> are in the new tiddler.
>>>> 2. what ist wrong, that the formulas not work:
>>>>
>>>> i have all tiddlers on the site http://mathcell.tiddlyspot.com/ are
>>>> listet importet.
>>>> then i have saved my wiki and closed.
>>>> Now i have do a new start of my wiki.
>>>>
>>>> thanks for answer
>>>>
>>>>
>>>> Am Donnerstag, 27. Februar 2020 07:21:09 UTC+1 schrieb Morgaine O'Herne:
>>>>>
>>>>> I did it like this: All of the data in the columns is in the Fields.
>>>>> You can see this at http://morgensharn.tiddlyspot.com. The tiddler
>>>>> is "Eriel - Armor Weight."
>>>>>
>>>>> @@.table
>>>>> |ITEM|WEIGHT|
>>>>> |{{!!a1}}|{{!!b1}}|
>>>>> |{{!!a2}}|{{!!b2}}|
>>>>> |{{!!a3}}|{{!!b3}}|
>>>>> |{{!!a4}}|{{!!b4}}|
>>>>> |{{!!a5}}|{{!!b5}}|
>>>>> |{{!!a6}}|{{!!b6}}|
>>>>> |{{!!a7}}|{{!!b7}}|
>>>>> |{{!!a8}}|{{!!b8}}|
>>>>> |{{!!a9}}|{{!!b9}}|
>>>>> |{{!!a10}}|{{!!b10}}|
>>>>> |TOTAL|<$macrocall $name="eval"
>>>>> cell="(=!!b1+!!b2+!!b3+!!b4+!!b5+!!b6+!!b7+!!b8+!!b9+!!b10)" format="2"
>>>>> target="armor">|
>>>>> @@
>>>>>
>>>>>
>>>>>
>>>>> On Sunday, February 23, 2020 at 12:49:12 AM UTC-7, Gerald Weis wrote:
>>>>>>
>>>>>> Hi Folks
>>>>>>
>>>>>> i have a table with 2 columns of numbers.
>>>>>> now i want to have the sum from every columns.
>>>>>>
>>>>>> the Position of the sum shoud be above or below the columns.
>>>>>>
>>>>>> I have no solution found for this.
>>>>>>
>>>>>>
>>>>>> Any Ideas?
>>>>>>
>>>>>> thanks for all
>>>>>>
>>>>> --
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "TiddlyWiki" group.
>>>> To unsubscribe from this topic, visit
>>>> https://groups.google.com/d/topic/tiddlywiki/W2pVlzHI4CM/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to
>>>> [email protected].
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/tiddlywiki/5b60ea08-3295-407e-a580-2043eabb9123%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/tiddlywiki/5b60ea08-3295-407e-a580-2043eabb9123%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to a topic in the
>> Google Groups "TiddlyWiki" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/tiddlywiki/W2pVlzHI4CM/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> [email protected] <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/tiddlywiki/d04e100f-8b34-4938-829a-200608b5969b%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/tiddlywiki/d04e100f-8b34-4938-829a-200608b5969b%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/235e4465-2dd0-4345-9aff-1b970b441be2%40googlegroups.com.
