当将值设置为变量时,SSRS的表达式似乎正在四舍五入
我的表情是从数据库中获取一美元金额,并将其存储到变量或将变量添加并添加一美元金额中,然后根据某些其他字段的标准更新变量,然后在文本框中显示变量。 似乎该变量被舍入整数,但仍显示两个小数点。如何防止变量被四舍五入? = if(fields!apbac_amount.value> 0 and fields!apbac_type.value =“ ap”或fields!apbac_type.value =“ bd”,变量! .value)和变量!
My expression is taking a dollar amount from the database and storing it into a variable or taking the variable and adding a dollar amount to it before updating the variable based on some other fields criteria, and then displaying the variable in the textbox.
It seems that the variable is being rounded to the whole number but still displaying two decimal points. How to keep variable from being rounded?=IF(Fields!APBAC_AMOUNT.Value > 0 And Fields!APBAC_TYPE.Value = "AP" Or Fields!APBAC_TYPE.Value = "BD", Variables!rptBalance.setValue(Variables!rptBalance.Value + Fields!AMOUNTRECEIVED.Value) And Variables!rptBalance.Value, Variables!rptBalance.setValue(Fields!APBAC_BALANCE.Value) AND Fields!APBAC_BALANCE.Value)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论