[Tex/LaTex] Align position of decimal point within tabularx

charactershorizontal alignmentsiunitxtablestabularx

I have made a table with 5 columns, of which I'd like the last 4 to be of the same width. Therefore I was told I should use tabluarx.
Using this package my output looks fine, but I have also numbers inside the last 4 columns, mixed with %-values. I'd like to adjust to the decimal point first PLUS then make the columns of equal width. Is this possible with any package out there? If not, can some1 show me the solution to only align to the decimal point? I wasn't able to solve it using siunitx, because I have also text inside my table (first column mainly).

Thanks for any help. Here is the MWE:

\documentclass[a4paper, 12pt]{scrreprt}
\usepackage{setspace}
\usepackage{booktabs}
\usepackage{floatrow}
\floatsetup[table]{capposition=top}
\usepackage{tabularx}
\newcolumntype{Y}{>{\centering\arraybackslash}X}

\begin{document}

\begin{table}[htpb]
\begin{tabularx}{0.85\textwidth}{lYcYcYcYcY}
    \toprule
    \multicolumn{1}{l}{Test 1} & \multicolumn{2}{c}{Test 2} & \multicolumn{2}{c}{Test 3} \\
    Observations successfull & no & yes  & maybe & no  \\
    adsadad & 546546.546 & 45.646 & 45.646 & 456.456 \\
    \% AAA & 235.25\% & 2525\% & 2342.34\% & 234.2525\% \\
    \% BBB & 0.0029 & N/A & 0.0031 & N/A \\
    \% CCC & 0.0033 & N/A & 0.0031 & N/A \\
    \bottomrule

\end{tabularx}
\end{table}

\end{document}

Let me know.

Best Answer

enter image description here

\documentclass[a4paper, 12pt]{scrreprt}
\usepackage{setspace}
\usepackage{booktabs}
\usepackage{floatrow}
\floatsetup[table]{capposition=top}
\usepackage{dcolumn}
\newcolumntype{Y}{D..{6.4}}

\begin{document}

\begin{table}[htpb]
\begin{tabular}{lYYYY}
    \toprule
    \multicolumn{1}{l}{Test 1} & \multicolumn{2}{c}{Test 2} & \multicolumn{2}{c}{Test 3} \\
    Observations successful &
\multicolumn{1}{c}{no} & 
\multicolumn{1}{c}{yes}  &
\multicolumn{1}{c}{maybe} &
\multicolumn{1}{c}{no}  \\
    adsadad & 546546.546 & 45.646 & 45.646 & 456.456 \\
    \% AAA & 235.25\% & 2525\% & 2342.34\% & 234.2525\% \\
    \% BBB & 0.0029 & \multicolumn{1}{c}{N/A} & 0.0031 & \multicolumn{1}{c}{N/A} \\
    \% CCC & 0.0033 & \multicolumn{1}{c}{N/A} & 0.0031 & \multicolumn{1}{c}{N/A} \\
    \bottomrule

\end{tabular}
\end{table}

\end{document}