XSLT逻辑：输出中的NaN，需要0 [英] XSLT logic : NaN in output, need 0

问题描述

 <Total>          
        
             <xsl:choose>
                    <xsl:when test="$SeqNumber != 1 and $SeqNumber != 5 ">
                        <xsl:value-of select="format-number(sum(//Details[(SenderNumber = $SNumber) and (SequenceNumber = $SeqNumber)]/LineSubTotal/text()) div sum(//Details[(SenderNumber = $SNumber) and (SequenceNumber = $SeqNumber)]/Qty/text()),'0.####') " />
                    </xsl:when>
               
                    
                    <xsl:otherwise>
                        <xsl:value-of select="sum(//Details[(SenderNumber = $SNumber) and (SequenceNumber = $SeqNumber)]/Price/text())" />
                    </xsl:otherwise>
                </xsl:choose>
                
        </Total>

基本上我需要1％0 = 0（我强烈要求这个逻辑）

Basically I need 1%0 = 0 (forcefully I want this logic)

我面临的问题是，如果'LineSubTotal'为零或空或'数量'为空，那么我收到NaN。

每当我收到NaN时，我需要输出为'0'

我怎样才能实现这个目标？

The issue I am facing is if 'LineSubTotal' is zero or empty or 'Qty' is empty then I am receiving NaN.
Whenever I receive NaN, I need to output as '0'
How can I acheive this ?

Reason101

Reason101

$

推荐答案

NaN =非数字

NaN = Not A Numeric

您需要检查计算中的所有数据是否确实数字

也可能由除以零IIRC引起

You need to check that all data in your calculations are indeed numeric
Could also be caused by division by zero IIRC

如果你能提供源xml文件，那么可以解决问题

If you can provide source xml documents it's possible to work out the issue

rgds

这篇关于XSLT逻辑：输出中的NaN，需要0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！