Opening Closing with rangesum for Unique Users

[rajni_batra]

Hi,

I am trying to calculate Opening and closing in front end for diff users but i am doing something wrong ,

its carry forwarding closing of all users and i want to calculate it individually for distinct users.

any help would be appreciated!!!

Thanks,

Rajni

[kavita25]

Hi,

PFA.

Its done as per ur requirement. Check it.

[rajni_batra]

Hi,

Kavita, Thanks for your reply.

i dont want this in back-end that would act static and if i remove any dimesnion from the chart it consolidate the opening and closing or i have to add some more expressions to get min and max of opening and closing.

Any way to do it in front-end.

Refer the file attached.

Thanks

[kavita25]

Y do you need to remove the dimensions??

Or even if dimension is removed, how the calculation should flow.?

[kavita25]

Hi,

PFA

Done.Check it. Same result is done in front end.

And if you want to remove the dimension you need to remove that field from Aggr function as I have used in the expression.

Hope it helps you now.

Regards,

Kavita

[sasiparupudi1]

Hi You need an aggregate function in your opening balance calculation

  aggr(rangesum(

    above(total sum(Bonus),1,RowNo(total))

    ,above(total -sum(Real),1,RowNo(total))

    ),UserID,UniqueID,Type,MoneyFlag, CreatedDateTime)

[rajni_batra]

Nope, Not working , After removing the date dimesnion and the same from aggr too , its picking up value of previous user.

[rajni_batra]

No luck

[kavita25]

What is the expected output after removing the Date dimension?