Skip to Content
Former Member
Feb 09, 2008 at 09:45 AM

Calculating the number of days based on transaction in Query


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.