电源应用程序从详细列表中计算总和

发布于 2025-01-31 20:28:01 字数 731 浏览 0 评论 0原文

我创建了一个使用2个表，“主”和“详细列表”的电源应用程序。在第一个屏幕上，我使用画廊列表从“主”表中列出了记录。在每一行上，我都有一个总字段，从“详细信息”表中选择并总和一个数字字段。我在标签字段的“项目”属性中使用以下函数：

Text(
  Sum(
    Filter(
      'Detail List',
      Staff.'Full Name'=ThisItem.Staff.'Full Name',
     'Leave Date'>=ThisItem.'Period From',
     'Leave Date'<=ThisItem.'Period To',
     'Leave Type'.Name="Annual Leave"),
    'Days Taken'),
  "#0.0")

上面的公式没有Power Apps Studio中的任何错误，但它会显示出错误：

Server Response: "Detail List" failed: The right side of the "GreaterThanOrEqual" operator can't be NULL.

公式可以产生正确的结果，但是当我打开时，错误消息始终显示我的手机上的应用程序。

我尝试将字段“从”和“周期”放入标签中，然后用dateValue（标签）替换相应的操作数，但也显示了相同的错误。

上述功能是否有任何错误，我该如何修复？

多谢！

原文

I created a Power Apps that use 2 tables, "Master" and "Detail List". On the first screen I listed the records from "Master" table using Gallery list. On each row, I have a total field which select and sum up a numeric field from "Details" table. I use the following functions in the "Item" property of the label field:

Text(
  Sum(
    Filter(
      'Detail List',
      Staff.'Full Name'=ThisItem.Staff.'Full Name',
     'Leave Date'>=ThisItem.'Period From',
     'Leave Date'<=ThisItem.'Period To',
     'Leave Type'.Name="Annual Leave"),
    'Days Taken'),
  "#0.0")

The above formula does not has any error from Power Apps Studio but it will show an error:

Server Response: "Detail List" failed: The right side of the "GreaterThanOrEqual" operator can't be NULL.

The formula can produce correct result but the error message always display when I open the app on my mobile.

I try put the field "Period From" and "Period To" into a Label and replace the corresponding operand with DateValue(Label) but the same error also displayed.

Is it any error on the above functions and how can I fix it?

Thanks a lot!

分享到QQ

分享到微博