0
Help us understand the problem. What are the problem?

posted at

PowerApps 累計する方法

以下のような累計をするには
image.png

累計するデータを作成

ClearCollect(table_y,
    {cnt_:150},
    {cnt_:200},
    {cnt_:100},
    {cnt_:90}
);

以下のように累計する

Clear(table_y_sum);
ForAll(
    Sequence(CountRows(table_y)),
    Collect(
        table_y_sum,{
            cnt_:Last(FirstN(table_y, Value)).cnt_ ,
            sum_:Last(FirstN(table_y, Value)).cnt_ + Last(FirstN(table_y_sum, Value + 1)).sum_
        }
    )
);

累計した結果
image.png

Register as a new user and use Qiita more conveniently

  1. You can follow users and tags
  2. you can stock useful information
  3. You can make editorial suggestions for articles
What you can do with signing up
0
Help us understand the problem. What are the problem?