National Market Projection Factor

[Anonymous]

I have the following preceding load:

[Distinct Script Data]:

LOAD [Script Number],

Count([Script Number]) as Rx

Group by [Script Number];

SQL SELECT DISTINCT

"Script Number"

FROM PharmaMarketAudit.dbo.tblDatawarehouseConsolidatedCleanStage

WHERE [Date Dispensed] >= '2012-01-01' and [Date Dispensed] <= '2015-08-31';

I want to make a projection from a sample to a national market figure by multiplying the Count([Script Number]) as Rx by a factor of 3, in other words tripling the count.  How can this be achieved with above load script at load time?

Regards

Message was edited by: Christopher Chitemerere

[#2 · Accepted solution]

have you tried

Count([Script Number])*3 as Rx

I have done this same type of concept in expressions but not in the load

[Anonymous]

Thank you Adam, you are right i tried it but was getting unexpected values.  I later realized that i had not adjusted one of my variables in order to effect this.