Distribution

[#1]

Hello everyone,

I have a problem of distributing the amount among different channels.

i want to distribute this 100 amount in the Revenue Field among all the other channels equally  in the Distribution field or like giving some percentage of the total amount.

Any suggestions or solution guys???

Thanks

[Gysbert_Wassenaar]

distribution: sum(total Revenue)/count(distinct Channel)

or something like sum(total Revenue)*sum(Spend)/sum(total Spend)

Change Revenue and Spend with the names of your fields (or with your expressions)

[#3]

Hi Gysbert Wassenaar .. thanks for your reply but the expression

sum(total Revenue)/count(distinct Channel)

gives me the value 100 for each channel where as i want 25  for each and i also want to distribute the revenue like where consecution is 1 , i want to give 30% of the revenue etc.

[#4]

hi Gysbert Wassenaar, thanks for your reply, I am attaching a sample application with this post in which i have defined the scenario what i need and explained what each field means....

It would be a great favour if you can suggest me some solution out of that.I am kind of stuk at this point.

THERE  are 2 book marks called example 1 and example 2 which will explain the situation more clearly to you.Thanks for your time.

Best Regards

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. I didn't understand what you mean with item 3, the distribution when all selections are cleared.

[#6]

Bundle of thanks Gysbert Wassenaar....I really appreciate it

[#7]

hi

Gysbert Wassenaar.

I have one more problem

Channel	Consecution	tag	spend	Revenue
AFF	1	F	10	30
PEG	2	other	10	15
SKS	3	L	10	40
AGH	4	other	10	15

in the above table i have distributed the revenue among all channel but now i donot want to give the Channel any revenue which comes after L tag..that is after the sales has  been made. so i need this

Channel	Consecution	tag	spend	Revenue
AFF	1	F	10	30
PEG	2	other	10	30
SKS	3	L	10	40
AGH	4	X	10	0

how i can  make X in th tag field at the script level??

I have used this expression for tag field,

If(consecution=1,'F',if(buyConsecution>=1,'L','other')))

BR!