Skip to main content
I am looking to combine every individual who has logged into one of our platforms, but having a difficult time specifying which rows to combine into the formula. 

 

Here is a screenshot for visual assistance:

 

Specify Particular Rows into Formula

 

I want to be able to pull the logins for just March, June, and July while leaving the 341 who have never logged on as a percentage. To grab the percentages you see above, I used "RowCount/PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)" as my formula. Please let me know how I pull just the specified months where there were logins. I appreciate it!
8 个回答
  1. 2015年7月13日 18:59
    here's the formula with your API name.

     

    Be sure to :

     

    1: Create the text formula field on the contact record

     

    2) Make sure Vault_Login_Created__c is of type Date

     

    (not datetime or text, etc)  if Datetime, using the formula at the bottom.

     

    Thx

     

    if Vault_Login_Created__c is a date

    CASE( MONTH(Vault_Login_Created__c),

    1,"January " + Text(Year(Vault_Login_Created__c)),

    2,"February "+ Text(Year(Vault_Login_Created__c)),

    3,"March "+ Text(Year(Vault_Login_Created__c)),

    4,"April "+ Text(Year(Vault_Login_Created__c)),

    5,"May "+ Text(Year(Vault_Login_Created__c)),

    6,"June "+ Text(Year(Vault_Login_Created__c)),

    7,"July "+ Text(Year(Vault_Login_Created__c)),

    8,"August "+ Text(Year(Vault_Login_Created__c)),

    9,"September "+ Text(Year(Vault_Login_Created__c)),

    10,"October "+ Text(Year(Vault_Login_Created__c)),

    11,"November "+ Text(Year(Vault_Login_Created__c)),

    12,"December "+ Text(Year(Vault_Login_Created__c)),

    "Non Successful Logins"

    )

     

    If the Vault_Login_Created__c type is datetime use this:

     

     

    CASE( MONTH(DATEVALUE(Vault_Login_Created__c)),

    1,"January " + Text(Year(DATEVALUE(Vault_Login_Created__c))),

    2,"February "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    3,"March "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    4,"April "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    5,"May "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    6,"June "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    7,"July "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    8,"August "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    9,"September "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    10,"October "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    11,"November "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    12,"December "+ Text(Year(DATEVALUE(Vault_Login_Created__c))),

    "Non Successful Logins"

    )