Free Support Forum -

Concatinating strings

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


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.