locked
Count Rows based on an optionaet value in CRM Online Fetchxml Report RRS feed

  • Question

  • Hi,

        I am new to FetchXml Reports, I have a Report in which i want to Sum the records which have different Optionset values

    Like Profit,NonProfit,Other.

    I want to calculate the number of rows which have options (Profit,NonProfit,NotApplicable) and show in other column.

    Thanks

    Wednesday, February 18, 2015 1:00 PM

All replies

  • you may have to use expression to do this.

    try

    https://msdn.microsoft.com/en-us/library/dd255237.aspx

    Jithesh

    Wednesday, February 18, 2015 10:37 PM
  • in a last row insert an expression:

    =sum(iif(Fields!IsOrganization.Value = "Profit",1,0) + iif(Fields!IsOrganization.Value = "NonProfit",1,0) + iif(Fields!IsOrganization.Value = "NotApplicable",1,0))
    It will count all rows with "Profit", "NonProfit" and "NotApplicable" text in IsOrganization field.
    • Edited by xjomanx Tuesday, March 3, 2015 1:01 PM
    Tuesday, March 3, 2015 12:59 PM