I need the below formula formatted “$#,#0.00” and it won’t do it. I think it’s possessed!
Would some one be so kind as to take this formula and format it for me? I would really appreciate it!
=FormatNumber(Sum( iif( Fields!Calc_OrderRelCounter.Value = 1 , CDbl( Fields!Calc_ExtPrice.Value ),CDbl( 0.0 )),“Group1”) - Sum( iif( Fields!Calc_OrderRelCounter.Value = 1 , CDbl( Fields!DocDiscount.Value ), CDbl( 0.0 )),“Group1”),First(Fields!DecimalsCost.Value, “RptParameter”))
Thank you!