cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating the number of days based on transaction in Query

Former Member
0 Kudos

Hi friends,

I would be greatful if u can help me out. I have got a situtation where in i need to take the day when the transaction has occured otherwise i dont need to take that day. For example if one transaction occurs on 1st , i need to take that day and if the transaction dosent occur then i need to ignore it. If there is one transaction or multiple transactions i need to take the day only once.

Like transaction has happened on 1st Jan so it will be considered,

on 2nd the transaction dosent happen so i need to ignore it

on 3rd there is a transaction so its taken.

So its like 1st - 1

2nd - 0

3rd - 1

So total will be 2.

Transactions are being taken from a cube. Kindly let me know as to how to do this in query.

Thanks,

Kapil

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Try use calculated key figure with count function (return 1 if value is <>0) as argument take base key figure which return value <> 0 if transaction has happened and use exception of aggregation on 0calday characterisctic.

Answers (1)

Answers (1)

Former Member
0 Kudos

PLease give us some more inputs.. requirement is not clear.

Do u have 0calday in ur Cube?

Khaja