Concatinating strings

aachuri · August 3, 2011, 4:25pm

I want concatinate strings in Calculated member.

pivotTable.AddCalculatedField("Leveraged Hours (Mgmt to Staff)", "=Round((SUM('ManagementHours')/(SUM('ManagementHours')+SUM('StaffHours')))*100,0)&//&Round((SUM('StaffHours')/(SUM('ManagementHours')+SUM('StaffHours')))*100,0)");

Result should look like Number1/Number2

shakeel.faiz · August 3, 2011, 6:50pm

Hi,

Please provide me Excel file with this formula already created by you manually using Ms-Excel. We will investigate how to create such a formula and provide you a sample code.