Derived Measure (fact)

[Anonymous]

I have the following in my load Script:

RangeSum(MedicalAidAmount, Shortfall) as Amount,

Is it possible to have a derived measure (fact) based on Amount, Like

0.2*Amount as OtherAmount

Regards.

Chris

[sunny_talwar]

Ya try it out. With the information provided, I don't think we can offer more help. If it doesn't work please provide more sample so that we can offer a better solution

Best,

Sunny

[Anonymous]

Hi Sunny

I get an error message on Concatenate (Table)

the message says Table not found

[sunny_talwar]

What is your table name where you are concatenating it into?

Table:

LOAD Company,

          Branch,

          QTY,

          Amount

FROM Source;

Concatenate (Table)

LOAD 'Manfred' as Company,

          'Fred' as Branch,

          Avg(QTY) * 0.2 as QTY,

          Avg(Amount) * 0.2 as Amount

Resident Table;

In my example Concatenate (Table) matches the Table I am concatenating into.

HTH

[Anonymous]

Yes i have the that, here with error message:

I have the table [Main Data] in my model

[sunny_talwar]

Can you share your script?

[Anonymous]

Hi Sunny, managed to sort it out, script was in the wrong place.  Will advise you of outcome

[sunny_talwar]

Sounds good

[Anonymous]

Thank you very much

[Anonymous]

Thanks Swuehl