0

flow fields

Hello.

One problem; maybe somebody might help.

We want to have rows only from article-groups ("Deb-Artikelrabattgr."), which one customer bought in a sum of e.g. 5.000 EUR per year.

But with the following data I get all article-groups, although sum of them ist lower than 5.000 EUR. So I get to much data.

 

=nl("Zeilen";"Provisionsposten";"Deb.-/Artikelrabattgr.";"Datenquelle=";"DWH";;;"Rechnungsdatum";$K$9;"Debitorennr.";$G14;"Betrag (MW)";"<>5")

We work also with cubes in Jet-Professionals; here I get the sum of the sales volume:

Is it possible to combine formula one and two?

=nl("CubeValue";"Provisionsposten";"[Measures].[Betrag_MW]";"Datenquelle=";"Cube_1";"[Buchungsdatum].[Time].[Date]";$T$7;"[Debitor].[Debitornr]";"@@"&$G14;"[Artikelrabattgruppe].[Code]";$J14)

            

Thank you

regards

Klaus

 

0 comments

Please sign in to leave a comment.