使用输入的当前和最后一行中的项目计算数据库条目 [英] calculate database entry using item from current and last row entered

问题描述

嘿伙计们！想知道是否有人会帮助我使用从当前和最后一行输入的项目来计算数据库条目？



我有一个从上一年的变化列我想要由当前条目的十进制数据类型与上一年的十进制数据类型之间的差异填充。



所以，如果我今年有20美元和去年15美元，我希望20美元的那一行还有一个去年的变化，显示5美元。



有人可以帮忙吗？



先谢谢！

解决方案

今年20岁和

< blockquote>去年15，我希望

20的行也有一个上一年的变化，显示

Hey folks! Was wondering if anyone would help me with calculating a database entry using item from current and last row entered?

I have a "change from prior year" column I would like populated by the difference between a decimal data type from the current entry and a decimal data type from the previous year.

So, if I had $20 this year and $15 last year, I would like the row with the $20 to also have a "change from prior year" that showed $5.

Can anyone help?

Thanks in advance!

解决方案

20 this year and

15 last year, I would like the row with the

20 to also have a "change from prior year" that showed

这篇关于使用输入的当前和最后一行中的项目计算数据库条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！