web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Rollup Field: Count bl...
Microsoft Dynamics CRM (Archived)

Rollup Field: Count blank or specific value

(0) ShareShare
ReportReport
Posted on by crmrsw15 685

Hi,

I have created a rollup field to count some records. I am running one of the filters on an option set field. I want it to count if the field is blank or if 2 of the values are selected. I thought I could do this by simply saying if the field value does not equal the two that I have selected , but it is not counting the blank fields. If I set an OR option to include in the count when the field is blank, then the OR operator then negates my other filters. 

I am surprised that by default blanks are counted. Is there a way I can achieve this?

Best wishes,

Richard

*This post is locked for comments

I have the same question (0)
  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Rollup Field: Count blank or specific value

    Hi,

     it's either all "AND" or it's all "OR" in rollups.

     I suspect you might want to inverse the filter (Contains Data AND NOT equals Option 4 AND NOT Equals Option 5 AND Not Equals Option 6...). Although, I'm not sure if you actually want to count blanks or not (since you wrote that you want it to count blank but you are surprised it's counted)

      If you want more advanced rollup filters(though I don't think you need it in your scenario), you'll need something custom. For example, here is one option:

      http://www.itaintboring.com/dynamics-crm/lets-roll-up/

  • crmrsw15 Profile Picture
    crmrsw15 685 on at
    RE: Rollup Field: Count blank or specific value

    Sorry if I was confusing. The issue here is that it DOESN'T count blank fields unless I specifically say does not contain data.

    The rollup field I am trying to achieve is:

    Field 1 = X

    AND Field 2 = X

    (AND Field 3 DOES NOT CONTAIN DATA OR Field 3 = X or X)

    Because of the first 2 fields I cannot negate it to use OR. Not sure how I can make this one happen, any ideas would be welcome.

    Thanks.

    Richard

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Rollup Field: Count blank or specific value

    If filed3 is an optionset, maybe you can do:

    Field 1 = X

    AND Field 2 = X

    AND Field 3 <> Option 3

    AND Field 3 <> Option 4

    AND Field 3 <> Option 5

    AND Field 3 <> Option 6

    etc

  • crmrsw15 Profile Picture
    crmrsw15 685 on at
    RE: Rollup Field: Count blank or specific value

    Thanks Alex. Yes that would work but I also need to count the blanks and that's where it falls over.

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Rollup Field: Count blank or specific value

    If you use "<>" with specific options, I think it will count blanks on Field 3

  • crmrsw15 Profile Picture
    crmrsw15 685 on at
    RE: Rollup Field: Count blank or specific value

    I would have thought MS would have made it easier by counting blank values. e.g. if field 3 <> option 1, means a blank value should be counted but it doesn't count it. It only counts the fields that contain data and are not equal to option 1

  • crmrsw15 Profile Picture
    crmrsw15 685 on at
    RE: Rollup Field: Count blank or specific value

    Yes that's what I thought to Alex, until I tested it.

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Rollup Field: Count blank or specific value

    Here is an example

    35373.1.PNG

  • crmrsw15 Profile Picture
    crmrsw15 685 on at
    RE: Rollup Field: Count blank or specific value

    No, your not quite getting what the issue is here. Thanks for trying though.

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Rollup Field: Count blank or specific value

    You mean it does not work with those settings when you use "does not equal" condition as per the screenshot above (not the "equals" condition)?

    "No, your not quite getting what the issue is here. Thanks for trying thoug"

    Ah.. ok. Maybe you could add a screenshot then. That usually helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans