You need to sign in to do that
Don't have an account?
FlipH
Summary Formula Field not working
Hey guys. I am having problems getting a summary formula field to show up in my report/dashboards. It's a very simple formula.
It is as follows: Account.MTD_Sales__c:SUM / User.Sales_Quota__c:SUM
Both of these fields exist and contain data in them, however, I am not seeing any results in my dashboards. It is checked in the "Select Columns to Total" field. I've tried refreshing the boards, creating the exact same formula again...etc. Nothing seems to work. Anyone got any ideas? Thanks!!
It is as follows: Account.MTD_Sales__c:SUM / User.Sales_Quota__c:SUM
Both of these fields exist and contain data in them, however, I am not seeing any results in my dashboards. It is checked in the "Select Columns to Total" field. I've tried refreshing the boards, creating the exact same formula again...etc. Nothing seems to work. Anyone got any ideas? Thanks!!
FlipH
The name of the actual summary formula field is "Percentage to Quota"
ILX_MJ
Got the exact same problem, I think it might be a bug...
FlipH
bumping this. Actually contacted SF rep but still wondering if anyone has answers. Thx
NPM
Is it showing on the chart in your report (not dashboard)? I found a while ago that the chart in the report really drives the dashboard.
FlipH
Thanks for your response, but it was not working in the chart/report either. However, it fixed itself this morning. Guess it was just a bug??
ILX_MJ
Mine magically fixed itself too... guess it was just a bug...