If statement in WNL

Phoenix Certara Forums Phoenix WNL basics
1

Dear all,

I am trying to calculate the renal clearance by Ae/AUC. I have AUC0-16, AUC0-24, and AUC0-48, Accordingly, I also have Ae0-16, Ae0-24, and Ae0-48. The renal clearance would be Ae0-48/AUC0-48 if available. If AUC0-48 is not available, CLR would be Ae0-24/AUC0-24. If AUC0-24 is not available either, CLR would be Ae0-16/AUC0-16.

I tried the if statement, if works for Ae0-48/AUC0-48 AND Ae0-24/AUC0-24, But the Ae0-16/AUC0-16 did not show any result.

could you please check what is the problem with the statement?

here is the statement

if(ISNULL(AUC048), AE024/AUC024,if(ISNULL(AUC024), AE016/AUC016,AE048/AUC048))

Thanks for your help in advance,

MDMD

2

Hi MBMD,

I think the issue is the order that the if statements are selected in. If the condition of both AUC0_48 & AUC0_24 not being calculated is true, then it will never get to the option of calculating your Ae0-16/AUC0-16.

In cases like this I tend to find it easier to start with the ‘last’ condition and work backwards e.g.

if(AUC048>0,AE048/AUC048,if(AUC024>0,AE024/AUC024,if(AUC016>0,AE016/AUC016
,‘Not Calculable’)))

Note the last condition returns a text result to make it clearer what happened, I think this is what you were trying to achieve.

Simon.

if_rcl.phxproj (124 KB)

3

Hi Simon,

Thanks for your reply! I tried your statement, and it worked! Another thing is, I find one AE048 is blank, so the result is blank, and I have to calculate this particular one as Ae024/AUC024 although its AUC048 normal. I am not sure if I should add more word in this if statement or I should add in a new transformation. What is your suggestion to include this situation?

Thanks,

MDMD

4

I’m not sure i understand your question, if any Amount Excreted has been recovered from urine then AE0_48 should not, IMO, be blank. If it is, it suggests a Data Management issue that shoudl be corrected at source (e.g. if AE0_24 was 50mg, then AE0_48 should be at least 50mg, it can’t be less, or missing.

But if you need to work around it for now yes I would personally first correct this data inconsistency and then run the existing code.

Simon.

5

Hi Simon,

Thanks for your prompt reply. I understand your concerns, and I will double check the data.

Thanks,

Mei