Block Chart Numbers

[bharatkishore]

Hi All,

I have block chart. And below image for your reference

Here you can see in the image that i am missing numbers instead of 91 i am getting as (1-120),instead of 151 i am getting as(51-180).. Can you please tell me how can i get the missing numbers.

Expression i have written for calculated dimension is:

=SubField([Ageing Buckets(Due in)],'in',1) & Chr(10)&SubField([Ageing Buckets(Due in)],'in',-1)&chr(10)

Thanks,

R. Bharat Kishore

[settu_periasamy]

Hi Bharat,

Can you post your [Ageing Buckets(Due in)]  Values?

[bharatkishore]

Hi Samy,

Please find the below image for the ageing bucket due in values...

[settu_periasamy · Accepted solution]

Hi,

Try this..

=if(WildMatch([Ageing Buckets(Due in)],'*in*'),
SubField([Ageing Buckets(Due in)],'in',1) & Chr(10)&SubField([Ageing Buckets(Due in)],'in',-1),[Ageing Buckets(Due in)])

[bharatkishore]

Thanks a lot Samy.. worked like a gem... I have one more query...I am not able to see full values..  Can i see the full values as well. Below image for your reference.

[settu_periasamy]

May be you can try with one more New Line (i.e chr(10) )

Like

=if(WildMatch([Ageing Buckets(Due in)],'*in*'),
SubField([Ageing Buckets(Due in)],'in',1) & Chr(10)&

SubField([Ageing Buckets(Due in)],'in',-1)&chr(10),[Ageing Buckets(Due in)])

But, i'm not sure, because some of the values of the square box is very small.

You can try increase the chart also.

[Chanty4u]

use chr(10)  in ur expression

or

='Text: ' & Concat(urfield ,',')

[bharatkishore]

I have tried by expanding the char and even given chr(10) but still i am not getting...Anything am i missing

[settu_periasamy]

Is it possible to provide the sample? Let me try it

[bharatkishore]

Hi Samy,

Please find the attached app...