Post reply

Substituting a Dash for a Zero value

  • February 3, 2016 at 7:37 am

    #304255

    I have a text box where I want to show a Dash character when the value is 0.00. The text box uses the following expression -

    =SUM(CDbl(IIF(Fields!CL_DISADV_FL.Value = "N", "0.00", Fields!CST_AMOUNT.Value)))

    I have the text box properties set to show a "dash" when 0.00, however, I am still getting 0.00 on the report.

    Any ideas?

    Thanks !

  • February 3, 2016 at 8:54 am

    #1856326

    If I try this -

    =Sum(IIF(Fields!CL_DISADV_FL.Value = "N", "0.00", CDBL(Fields!CST_AMOUNT.Value)))

    I get the following error -

    Warning1[rsAggregateOfNonNumericData] The Value expression for the textrun ‘CL_DISADV_FL.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function on data that is not numeric. Numeric aggregate functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate numeric data. N:\MikeC\SSRS Reports\VendorActivityByEEOC\Vendor_Activity_By_EEOC.rdl00

  • February 3, 2016 at 9:02 am

    #1856328

    The fix is to take the quotes off 0.00. Appears they were overriding the textbox properties.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply