4 Replies Latest reply on May 10, 2018 4:08 AM by shanmukh.kamarthi.1

# Count of transactions and all others

Hello,

Kindly assist to get count of transactions for Top 10 and others. I have arrived at total sum of top 10 and others but unable to do count of the same.

(Working)This is for total sum:

IF ([In top n?]) THEN

SUM([2018 Amount])

ELSEIF ([Show All Sub LOB]) THEN

SUM([2018 Amount])

ELSEIF ([Others?]) then

WINDOW_SUM(SUM([2018 Amount]), 0, LAST())

ELSE

NULL

END

(Not Working) for count:

IF ([In top n?]) THEN

COUNT([Voucher ID])

ELSEIF ([Show All Sub LOB]) THEN

COUNT([Voucher ID])

ELSEIF ([Others?]) then

WINDOW_COUNT(COUNT([Voucher ID]), 0, LAST())

ELSE

NULL

END

Calculations used:

In top n?:

[Top 5] <= [Top x choice]

*Top 5 = Index()

*Top X Choice = Parameter

Show All Sub LOB:

Parameter (Boolean)

Others?:

[Top 5] = [Top x choice] + 1

• ###### 1. Re: Count of transactions and all others

What is the Error..Can you show screenshot

(Not Working) for count:

IF ([In top n?]) THEN

COUNT([Voucher ID])

ELSEIF ([Show All Sub LOB]) THEN

COUNT([Voucher ID])

ELSEIF ([Others?]) then

WINDOW_COUNT(COUNT([Voucher ID]), 0, LAST())

ELSE

NULL

END

• ###### 2. Re: Count of transactions and all others

You can see that for 52 others amount is being summed up where count is showing only 52 which would be for one of the row not for all others? do you follow me?

• ###### 3. Re: Count of transactions and all others

IF ([In top n?]) THEN

COUNT([Voucher ID])

ELSEIF ([Show All Sub LOB]) THEN

COUNT([Voucher ID])

ELSEIF ([Others?]) then

WINDOW_COUNT(COUNT([Voucher ID]))

ELSE

NULL

END

Try This

• ###### 4. Re: Count of transactions and all others

No luck tried the above way