Template:BTD4 upgrade info: Difference between revisions

mNo edit summary
mNo edit summary
Line 18: Line 18:
</tab>
</tab>
</tabs>
</tabs>
|-
{|class="info-sub centered-cells"
|
{|class="info-sub"
!Tower
!Tower
|colspan="2"|[[{{{tower}}} (BTD4)|{{{tower}}}]]
|colspan="2"|[[{{{tower}}} (BTD4)|{{{tower}}}]]
!Tier
!Tier
|colspan="2"|{{{tier}}}
|colspan="2"|{{{tier}}}
|}
{|class="info-sub
!colspan="3"|Costs and sell values
|-
|-
!colspan="2"|Cost
!Upgrade cost
|colspan="4"|This upgrade: ${{formatnum:{{{cost M|0}}}}}<br>Total: ${{#cargo_query:table=btd4_upgrades
!colspan="2"|${{formatnum:{{{cost M|0}}}}}
|-
!Total cost
!colspan="2"|${{#cargo_query:table=btd4_upgrades
|fields=FORMAT(SUM(cost_M), 0)
|fields=FORMAT(SUM(cost_M), 0)
|group by=tower
|group by=tower
|where=tower="{{{tower}}}" AND tier<={{{tier}}}
|where=tower="{{{tower}}}" AND tier<={{{tier}}}
}}<br>Sell value: ${{#cargo_query:table=btd4_upgrades
}}
|-
!Sell value
!colspan="2"|${{#cargo_query:table=btd4_upgrades
|fields=FORMAT(SUM(cost_M)*0.8, 0)
|fields=FORMAT(SUM(cost_M)*0.8, 0)
|group by=tower
|group by=tower