Distributing amount in buckets on front end

[#1]

Hi All,

I am facing issues in distributing the amount on the front end among the Buckets.

Ex: Amount to be distributed : 240

From	To	Required Amount
0	100	100
100	200	100
200	300	40
300	99999	0

Please advise !!!

[CELAMBARASAN · Accepted solution]

Hi,

Try with this expression

if(Sum (Values)>To, To-From, If(Sum(Values)>From, Sum(Values)-From, 0))

[#3]

Hey,

Thanks a ton!!

Its much simplified.

[#4]

great solution.

[CELAMBARASAN]

You could close this post by marking Correct/Helpful answer.

[#6]

Ohh yaa but unfortunately, i don't see any such option on my screen. Please guide me if you don't mind.

[CELAMBARASAN]

It will be at bottom left of all the replies.

Hope it might be your browser problem

[#8]

Yes may be..This  is what I can see. Earlier I have done this. But this time, I cant see any option.

Soon i'll try to find out and would mark it correct.

[jagan]

Hi,

I think you need to login.

Regards,

Jagan.

[tresesco]

I suggest to write to community manager Sara Leslie