none
SSRS Expression Help!!!

    Question

  • How do I create this expression in the FX "=SUM(F2:F512)/SUM(E2:E512)" ?

    The F Column is   "=E2*C2"

    Here is what I have and it is an #Error:

    =Sum(Fields!CurrentRoomNights.Value * Fields!TotalAverageLOS.Value)/Sum(Fields!CurrentRoomNights.Value)

    Friday, February 09, 2018 9:15 PM

Answers

  • like this

    =IIf(Sum(val(Fields!CurrentRoomNights.Value)) > 0,Sum(val(Fields!CurrentRoomNights.Value) * val(Fields!TotalAverageLOS.Value))/IIf(Sum(val(Fields!CurrentRoomNights.Value)) >0, Sum(val(Fields!CurrentRoomNights.Value)),1),0)


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    • Marked as answer by soldierfc Monday, February 12, 2018 4:03 PM
    Saturday, February 10, 2018 6:13 AM