You need to round the value returned from GETPIVOTDATA
=ROUND(GETPIVOTDATA("Sum of 24 months",pivot!$A$7,"Metric","M1:Achievement of Permanency","DataElement","Cumulative %","Description","Adoption","year",2006),2)
You need to round the value returned from GETPIVOTDATA
=ROUND(GETPIVOTDATA("Sum of 24 months",pivot!$A$7,"Metric","M1:Achievement of Permanency","DataElement","Cumulative %","Description","Adoption","year",2006),2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks