Sum value Exception

[asknyldz]

Hi there,

Here is the dashboard.

I want to if Account_Status__c = Lower, it should be not sum in chart.

By the way, why i can't see Account_Status__c values in my chart.

Regards,

[sasiparupudi1]

Change

Table1:

Load

    Id,

    Num#(Amount,'0.0') as Amount

Resident Opportunity_SQL

To

Table1:

Noconcatenate Load

    Id,

    Num#(Amount,'0.0') as Amount

Resident Opportunity_SQL

[asknyldz]

Dear Prashant,

Here is the dashboard. I need to below result in my chart table, why i can't success.

Account_Status__c	SUM(Amount)
Active	100
Pending Data Validation	150
Pending Sales Leader Approval	125
Rejected	175
Unassigned	75
Unsubmitted	50
Total	675

[asknyldz]

Dear Parupudi,

Here is the dashboard. I need to below result in my chart table, why i can't success.

Account_Status__c	SUM(Amount)
Active	100
Pending Data Validation	150
Pending Sales Leader Approval	125
Rejected	175
Unassigned	75
Unsubmitted	50
Total	675

[Kushal_Chawda]

try below script

CUSTOM CONNECT TO "Provider=QvSalesforceConnector.exe";

Opportunity_SQL:

Load

Id,

Num#(Amount,'0.0') as Amount;

SQL

SELECT

Id,

Amount

FROM

Opportunity

WHERE

FiscalYear = 2017

;

Left Join(Opportunity_SQL)

LOAD Id,

Account_Status__c;

SQL

SELECT

Id,

Account_Status__c

FROM

Account

;

[asknyldz]

Thanks Kushal,

I tried but unfortunately.

Attached is the results.

[Kushal_Chawda · Accepted solution]

Please check that the Id values from both the tables are matching or not. Seems it's not matching there for it's not joining the table correctly. Meaning that Id in opportunity table where you have amount is having blank values in Account table

[asknyldz]

Yes my mistake, it was Company_Number__c, not ID