Problem with straight table (Conditional sum)

[francisvandergr]

I have a problem with a straight table. When i select group 510, i wanna see in my straight table all searchcodes and in the week the total quantity of searchcodes to deliver in that week.

For example: For searchcode : PKFY-P32 VHM-E i wanna see in week 43 a quantity of 2 and in week 49 a total quantity of 1. (see purchaseorders)

We don't want select a week first. Can someone help me? I have attached an example database

[#2]

Hi,

take a look at my straight table in your application. I put the delivery-week as a dimension and the rest was easy.

Ragards

[francisvandergr]

Thank you this works i know. The problem is that my customer want the weeks in columns. Do you know if this is possible ?

[#4]

Hi,

as far a I know not with straight tables. Then I suppose you do not want to use a Pivot Table. There it is possible, to scratch the dimension into the hrizontal.

OK, ganna look at your Expression.

[#5]

I build in the week as a calculated expression. Look at my app. again. Then you need to check "Supress Nulls" I think thats the way you want it. And I hided the delivery week.

Regards

Roalnd

[#6]

BTW:

What about the Year. Didn't you forget the Year in your expression ?

[francisvandergr]

It is an example. I think i can do this by combine Year and week. Year(Leverdatum) & week(leverdatum)

[francisvandergr]

But a better solution is always welcome of course !

[#9 · Accepted solution]

Oh,

and I found two other things concerning your expressions:

sum(If (Week(Ink\Leverdatum) = Week (Today())+1, (Ink\Aantal),0 ))

To work correct, the sum has to be outside. The if is inside the sum. Means, you want to sum the the content of Aantal, when the weeks are matching. Else not.

And I am sure you want to compare with the next week "week() +1", and not with the week of the next day ( week(today+1) )

If you correct that, your app should work. Sorry, that I saw these topics too late.

Roland

[francisvandergr]

Thnx for your time. You helped me very much!! It works