topic Re: Issue with measure in App Development

Issue with measure

Anonymous — Wed, 03 Oct 2018 09:01:06 GMT

I want to count the amount withdrawn by each user in a range of dates and came up with this:

Sum(distinct if(Date([Withdrawals.PaymentDate]) <= Date(Aggr(nodistinct SomeDays +

min([Deposits.PaymentDate]),[UserId])), [Withdrawals.BaseAmount], 0))

I do realise that the 'distinct' returns errors (it does not account for withdrawals made of the same amount within the dates).

However, without it the final output is waaay too big.

Re: Issue with measure

YoussefBelloum — Wed, 03 Oct 2018 09:14:59 GMT

Hi,

it is better to share sample app or sample data

Re: Issue with measure

Anonymous — Wed, 03 Oct 2018 09:25:34 GMT

I have:

Withdrawal Date Amount UserId

1/1/18 10 1

2/1/18 20 1

1/1/18 30 2

2/1/18 10 3

Extract The amount withdrawn up to:

Date(Aggr(nodistinct min([Deposits.PaymentDate]) + SomeDays, UserId))

For the example above let's say it equals to: 1/1/18.

Expected Result:

UserId Amount

1 20

2 30

3 0

Re: Issue with measure

YoussefBelloum — Wed, 03 Oct 2018 09:40:32 GMT

EDITED

try this:

sum({<[Withdrawal Date]={"<=1/1/18"}>}Amount)

Re: Issue with measure

Anonymous — Wed, 03 Oct 2018 09:58:30 GMT

To my actual dates and variables, that would translate into:

sum({<[Withdrawals.PaymentDate] <= {Date(Aggr(nodistinct SomeDays +

min([Deposits.PaymentDate]),[UserId]))}>}[Withdrawals.BaseAmount])

Which returns an 'Error in expression'.

Re: Issue with measure

Anonymous — Wed, 03 Oct 2018 15:32:21 GMT

Managed to come by the right solution:

Sum(if(Date([Withdrawals.PaymentDate]) <= Aggr(nodistinct Aggr(nodistinct min([Deposits.PaymentDate]),UserId),[Withdrawals.UserId]) + SomeDays, [Withdrawals.BaseAmount]))