invalid expression

[#1]

Hi,

I am getting this error.

Invalid expression

Concatenate (BIOGraph)

Load UID,

     'Baselined' as Category,

     if( [BaselineSaveDate] > '1998/09/09' ,1,0) as value,

     if( [BaselineSaveDate] > '1998/09/09',count(UID))/count(UID) as PercentValue

Resident ProjectTracker

what is the issue?

Thanks

[rubenmarin · Accepted solution]

Hi Amit, you are using count() without a Group by, try something like:

Concatenate (BIOGraph)

Load UID,

     'Baselined' as Category,

     if( [BaselineSaveDate] > '1998/09/09' ,1,0) as value,

     if( [BaselineSaveDate] > '1998/09/09',count(UID))/count(UID) as PercentValue

Resident ProjectTracker

Group by UID, [BaselineSaveDate];

[#3]

Hi Ruben,

Thanks a lot.