# % AUC extrap not populate in Pivot form

**URL:** <https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725>\
**Category:** Phoenix WNL basics\
**Created:** [December 18, 2023, 8:57am UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725 "2023-12-18T08:57:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![nileshg](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@nileshg](https://forum.certara.com/u/nileshg)\
**Post date:** [December 18, 2023, 8:57am UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725/1 "2023-12-18T08:57:27Z")

</div>

Hi ,

I am having some issue with pivoting data,

briefly, I have IV PK from 3 individual, I ran NCA analysis then calculated descriptive stat from final NCA parameter table, then used data wizard to combine mean ±SD column, and then pivot this data. But to my surprise, all selected parameters appear in pivot table except AUC%extrap, no value got populated for this parameter. Can you please suggest what can be done.

---

<div class="post-metadata">

**Author:** ![SimonDavis](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SimonDavis](https://forum.certara.com/u/SimonDavis)\
**Post date:** [December 18, 2023, 2:55pm UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725/2 "2023-12-18T14:55:33Z")

</div>

are you able to attach your project to see the problem - it might a weird quirk of having a % symbol inthe column name.

Simon.

---

<div class="post-metadata">

**Author:** ![nileshg](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@nileshg](https://forum.certara.com/u/nileshg)\
**Post date:** [December 18, 2023, 7:27pm UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725/3 "2023-12-18T19:27:23Z")

</div>

> [@sdavis](#):
>
> [pivot table issue.phxproj](https://forum.certara.com/uploads/short-url/iJHSlmzbS6HM9rVSyRxSOvYyIVb.phxproj) (356 KB)
> 
> Simon.

Hi Simon,

Please find attached file.

Thank you

Nilesh

---

<div class="post-metadata">

**Author:** ![SimonDavis](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SimonDavis](https://forum.certara.com/u/SimonDavis)\
**Post date:** [December 19, 2023, 11:30am UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725/4 "2023-12-19T11:30:39Z")

</div>

yes it was the percent in the variable name causing the issue. please see the second workflow where I have worked around this for you;

[pivot table issue\_simon.phxproj](https://forum.certara.com/uploads/short-url/lhF4orfrL83YnPPkBNVhtmkSqJw.phxproj) (726 KB)

 ![solved.jpg](https://us1.discourse-cdn.com/certara/original/2X/8/8b354fc283690d06140bfa7211003288a39f5fd3.jpeg)

---

<div class="post-metadata">

**Author:** ![nileshg](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@nileshg](https://forum.certara.com/u/nileshg)\
**Post date:** [December 19, 2023, 12:01pm UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725/5 "2023-12-19T12:01:40Z")

</div>

> [@sdavis](#):
>
> yes it was the percent in the variable name causing the issue. please see the second workflow where I have worked around this for you;

Thanks Simon,

Can you please describe in short the work around for this, I could not figure out from the file. The file I shared was just part of my template, I need to implement this on another one.

Regards,

Nilesh

---

<div class="post-metadata">

**Author:** ![SimonDavis](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SimonDavis](https://forum.certara.com/u/SimonDavis)\
**Post date:** [December 19, 2023, 12:15pm UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725/6 "2023-12-19T12:15:02Z")

</div>

Nilesh, I simply went back to your NCA object and renamed the variables that had % in them to remove them.  
I could probably have done it in the Data Wizard too but seemed more efficieint to do it at the beginning of the workflow.

If you want them back in you can add a percent symbol back in graph labels, or to column names etc in a table.

Simon.

 ![rename.jpg](https://us1.discourse-cdn.com/certara/original/2X/9/9cfad71a0f1c58edc8be8803f104a7ea9667b3b4.jpeg)

---

<div class="post-metadata">

**Author:** ![nileshg](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@nileshg](https://forum.certara.com/u/nileshg)\
**Post date:** [December 19, 2023, 3:27pm UTC](https://forum.certara.com/t/auc-extrap-not-populate-in-pivot-form/3725/7 "2023-12-19T15:27:56Z")

</div>

> [@sdavis](#):
>
> Nilesh, I simply went back to your NCA object and renamed the variables that had % in them to remove them.  
> I could probably have done it in the Data Wizard too but seemed more efficieint to do it at the beginning of the workflow.
> 
> If you want them back in you can add a percent symbol back in graph labels, or to column names etc in a table.
> 
> Simon.

Thanks a lot