Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SKIP ROW based on an attribute in one sheet of a multi sheet excel template

edited Nov 25, 2019 7:40PM in Reporting and Analytics for ERP 11 comments

Summary

I have a summary and detail excel template. I need to suppress rows which have a value of zero on one particular attribute of the row.

Content

I have inserted the following in Data Constraints of the XDO_METADATA.

<xsl:if test="number(.//COST_DIFF)!=0"> <xsl:value-of select=".//COST_DIFF"/> </xsl:if>

COST_DIFF is in the Detail sheet and the rows to be suppressed from display are in the Detail sheet only.  However it's not applying this because I think somewhere we should say this condition is for the detail sheet.

Any ideas are much appreciated.

Dilip

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!