Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!!
Hi,
Try with this expression
if(Sum (Values)>To, To-From, If(Sum(Values)>From, Sum(Values)-From, 0))
Hey,
Thanks a ton!!
Its much simplified.
great solution.
You could close this post by marking Correct/Helpful answer.
Ohh yaa but unfortunately, i don't see any such option on my screen. Please guide me if you don't mind.
It will be at bottom left of all the replies.
Hope it might be your browser problem
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.
Hi,
I think you need to login.
Regards,
Jagan.
I suggest to write to community manager Sara Leslie