Apex Code Development You need to sign in to do that
Don't have an account?
SoCal Admin Does Charting support math? / Bug?
Anyone know how to get Charting to use math instead of concatenation? The Chartclass is concatenating decimal variables instead of adding them.
I'm trying to create a stacked bar graph of 5 different products. DeveloperConsole output shows the queried values are correct.
But when I try to SUM to values to create the Y Axis, it ends up like this: (see highlight)
from DeveloperConsole:
VCur: 3433.23
lmonth: 1222.32
lqtr: 454.34
lsales: 887.34
lprod: 232.23
vTotal: 3433.231222.32454.34887.34232.23
(this is a defined as a Decimal variable - how is this possible)?
I also tried casting each value - but no luck.
Here is the code:
Decimal VCur;
Decimal lmonth;
Decimal lqtr;
Decimal lsales;
Decimal lprod;
List<AggregateResult> qCur = [Select Sum(salesAmt__c) Sum from CTest__c where... ];
List<AggregateResult> qmonth = [Select sum(salesAmt__c) Sum from CTest__c where ... ];
List<AggregateResult> qqtr = [Select sum(salesAmt__c) Sum from CTest__c where ...];
List<AggregateResult> qsales = [Select sum(salesAmt__c) Sum from CTest__c where ...];
List<AggregateResult> qprod = [Select sum(SalesAmt__c) Sum from CTest__c where...];
for (AggregateResult ar : Cur) {
vCur = (Decimal)ar.get('Sum');
}
System.Debug('VCUR = ' + vCur);
for (AggregateResult ar : qmonth) {
lmonth = (Decimal)ar.get('Sum');
}
System.Debug('lmonth = ' + lmonth);
for (AggregateResult ar : qqtr) {
lqtr = (Decimal)ar.get('Sum');
}
System.Debug('lqtr = ' + lqtr);
for (AggregateResult ar : qqtr) {
lsales = (Decimal)ar.get('Sum');
}
System.Debug('lsales = ' + lsales);
for (AggregateResult ar : qprod) {
lprod = (Decimal)ar.get('Sum');
}
System.Debug('lprod = ' + lprod);
Decimal vTotal = vCur + lmonth + lqtr + lsales + lprod;
System.Debug('vTotal = ' + vCur + lmonth + lqtr + lsales + lprod);
Found the problem:
The System.Debug function converts the decimal parameters as STRINGs when listed in the function call.
In my original casting attempts I was trying to solve the problem without a dedicated variable. But I never replaced the parameters with the dedicated variable.
This is still non-intuitive, and should be castable.
This: System.Debug(x + y + z), for Decimal reports this: "123" instead of "6"
This: int a = x + y + z
System.Debug(a) reports the correct value of: "6"
All Answers
Found the problem:
The System.Debug function converts the decimal parameters as STRINGs when listed in the function call.
In my original casting attempts I was trying to solve the problem without a dedicated variable. But I never replaced the parameters with the dedicated variable.
This is still non-intuitive, and should be castable.
This: System.Debug(x + y + z), for Decimal reports this: "123" instead of "6"
This: int a = x + y + z
System.Debug(a) reports the correct value of: "6"
System.Debug has only one signature, and that is System.Debug(String). When you pass decimal arguments to it, it implicitly casts the arguments as strings. If you pass Decimal + Decimal as an argument, the + is treated as a concatenation operator since the argument to the function is assumed to be a String. It's the downside of operator overloading.