adding calculated values in dimension

[sarfaraz_sheikh]

Dear All ,

I am stuck in one  problem ....Look at my table below ...I want to add one more value in Remarks which will show the percentage between two fields.There is requirement like this from user..

For Example:  CExcellent is what Percentage of AFaboulous 

I want the output like below snapshot ....Look at below snapshot conversion values has added there ..but my concern is i should get percetage there and calculation will be like this

57000 / 212000 * 100 = 27% ......27 % should show as Sum of salary of conversion value.

I tried with below code ..........but not getting as expected ...i think i am doing wrong somewhere ..kindly help

[sarfaraz_sheikh]

any help would be much appriciable ....Dear hic please suggest any way

sarfaraz

[#3]

Hi,

what is the expression for that conversion?

[sarfaraz_sheikh]

Hi,

i am using below code to achive the same .....

Load

'Conversion' AS Remarks,

Lookup('SALARY','Remarks','CExcellent','Raw') / SALARY  * 100 AS SALARY

resident Raw where Wildmatch(Remarks,'AFaboulous');

Sarfaraz

[sarfaraz_sheikh]

If know the solution then it would be much appreciable .......

Sarfaraz