Dual function issue

[buzzy996]

hi guys,

i'm trying use dual to display values on single bar like this "exp: 20 (30%)"

If i use this Count({$<Month=>}IP_No__c)--i'm getting 20

If i use this Num(Count({$<Month=>}IP_No__c)/Count(Total{$<Month=>}IP_No__c),'0.00%')*100 --- getting output as 30%

but i'm getting issue with the below expression,nay help?

dual(Count({$<Month=>}IP_No__c) & chr(10) & Num(Count({$<Month=>}IP_No__c)/Count(Total{$<Month=>}IP_No__c),'0.00%')*100,Count({$<Month=>}IP_No__c))

thanks in advance.

[sunny_talwar]

What is the issue that you are running into? Have you checked 'Expression Default' on the Numbers tab?

[buzzy996]

yes ,sunny,

the above dual() is only giving value and it's not producing % value along with number (like in the above exp), no error.

any help?

[sunny_talwar]

Did you try to check 'Expression Default' on the Number tab of chart properties?

[buzzy996]

Yes,

[sunny_talwar]

Would you be able to share a sample where this isn't working?

[buzzy996 · Accepted solution]

Hey,found small thing  (K) was placed on Thousand symbol that actually caused issue.

[sunny_talwar]

Super