Calculate Difference With Cumulative Total

Дата публикации: Apr 29, 2025

Задача

How to calculate the remainning product numbers to be shipped based on the information of Order Quantity and Shipment Quantity?

Действия

1. Create the following calculation field Numbers to be shipped

SUM([Order Quantity])-WINDOW_SUM(SUM([Shipment Quantity]),FIRST(),0)

2. Computes the above table calculation field within the dimension Ship Date.
User-added image

3. Add Numbers to be shipped to the view

Номер статьи базы знаний

001458745

Эта статья решила вашу проблему?

Оставьте свой отзыв, чтобы мы могли стать лучше!