6 Replies Latest reply: Feb 6, 2013 10:43 AM by salman12

# Distribution

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

• ###### Re: Distribution

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)

• ###### Re: Distribution

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.

• ###### Re: Distribution

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

• ###### Re: Distribution

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

• ###### Re: Distribution

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

• ###### Re: Distribution

hi

I have one more problem

ChannelConsecutiontag
spendRevenue
AFF1F1030
PEG2other1015
SKS3L1040
AGH4other1015

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

ChannelConsecutiontagspendRevenue
AFF1F1030
PEG2other1030
SKS3L1040
AGH4X100

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

I have used this expression for tag field,