Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following table:
Product | OrderID | Type | OrderSum$ |
A | 1 | 1 | 100 |
A | 1 | 1 | 200 |
A | 2 | 1 | 500 |
B | 4 | 1 | 600 |
B | 4 | 2 | 100 |
B | 5 | 1 | 800 |
I would like to calculate the sum of "OrderSum$" group by "OrderID" which the sum of the order is bigger then 400$ and the type of the order is 1 and display it by "product" -
for example: Product "A" has 2 orders the sum of orderID "1" is 300$ and the sum of orderID "2" is 500$, so only orderID ="2" should be displayed because the sum of the order is bigger then 400$
the final table should look like:
Product | OrderSum$ |
A | 500 |
B | 1400 |
I attached QVW for example.
Try this
Sum(Aggr(
If(Sum([OrderSum$]) >= 500, Sum([OrderSum$]))
, Product, OrderID))
hi
this expressions should work for you
sum(aggr(if(sum({<Type={"1"}>}OrderSum$)>400,sum({<Type={"1"}>}OrderSum$)),OrderID,Product))
Try this
Sum(Aggr(
If(Sum([OrderSum$]) >= 500, Sum([OrderSum$]))
, Product, OrderID))
hi
this expressions should work for you
sum(aggr(if(sum({<Type={"1"}>}OrderSum$)>400,sum({<Type={"1"}>}OrderSum$)),OrderID,Product))
Thank you all!