need help to calculate an expression??

[sushil353]

Hi All,

I have a pivot table in which i have calculated dimensions as

=aggr(sum({<test_fail_fdat.TT_TYPE=>}test_fail_fdat.TOTAL_FAILURES),test_fail_fdat.TT_TYPE)&'/'    for FAILURE

and

=aggr(sum(TOTAL_UNITS_PROCESSED),LOCATION_DESCR,OT_TYPE)   for TESTED

I need to calculate yeild % and that should be ( Failure/Tested )* 100 and it  should  be shown  before  test  field

How can i calculate this in pivot table...

Please find the attached xl file which is exported from pivot table and application ..

Thanks

Sushil

[#2]

Hi ,

Use the Column function to find your desired output.

for ex:.

Failure the first expression.

column(1)/column(3)*100 as % Field .

Testing the third exppression.

Good Luck

Regards,

Nitin Jain

[jagan]

Hi,

Just add this expression ([Failure Expression Name]) / ([TESTED Expression Name]) * 100 and move the expression to the position you wish.

I think you know we can use the Expressions in another expression.

Regards,

Jagan.

[sushil353]

hi jagan,

thanks for your reply...

but i am not able to calculate as per your suggestion... i have added sample application... please help me to solve this..

Thanks

[sushil353]

Hi Nitin,

Thanks for your reply.. i have added the sample application.. Please help me out to solve this issue... as i am not able to solve as per your suggesstion.

Thanks

[sushil353]

+jagan,

the formula i am calculating as a dimension not the expression...

i have attached the application..

Thanks

[jagan]

Hi,

Is it possible to calculate Failure and Tested values in Script during load using Group by.

Regards,

Jagan.

[sushil353]

+jagan

I think that would not be possible.. 😞

Regards

sushil