4 Replies Latest reply: Jul 9, 2014 10:39 PM by Satyadev Jaiswal

# expression combination

Hey All

Need to make a combination expression :

Following expression is working

=count({<Date={">=\$(vStartDate)<=\$(vEndDate)"}>}SALES)

13/01/2014     EDI                                                EDI

13/01/2014     KLBIKK                                          KLBIKK

14/01/2014     BLE014                                          BLE014

14/01/2014     EDI + 20                                         EDI + 20

Need the following overview - total of all directive and total of all EDI*

Total              4                                                   2

13/01/2014     2                                                   1

14/01/2014     2                                                   1

Can some help me out plse

Tks

Rudi

• ###### Re: expression combination

can you briefly explain how below coming?

Total              4                                                   2

13/01/2014     2                                                   1

14/01/2014     2                                                   1

• ###### Re: expression combination

UNLOAD_TO_DIRECTIVE = COUNT OF ALL ITEMS UNDER UNLOAD_TO_DIRECTIVE IN THIS CASE 4

EDI = COUNT OF EDI AND EDI* IN THIS CASE 2

• ###### Re: expression combination

Hi,

Create a Straight table and try like this

Dimension : Date

Expression 1 - Total of all Directive:

=count({<Date={">=\$(vStartDate)<=\$(vEndDate)"}>}SALES)

Expression 2 - Total of all EDI:

Now select Sum of Expressions option in

Chart Properties -> Expression tab.

Regards,

Jagan.

• ###### Re: expression combination

See attachment.