gauge charT

[manoranjan_d]

PAYING_WAY	PAID DETAILS	AMT
BANK	NOTNULL	100
CHEQUE	NULL	200
BANK	NOTNULL	300
CHEQUE	NULL	400
BANK	NOTNULL	500
CHEQUE	NULL	600
BANK	NOTNULL	700
CHEQUE	NULL	800
BANK	NOTNULL	900
CHEQUE	NULL	1000
BANK	NULL	1100
BANK	NULL	1200
BANK	NULL	1300
BANK	NULL	1400

above is my data i need the count for notnull paid details fields for only paying way = bank in percentage wise where the gauge should show the percentage of not null

so i tried the expression its not coming correctly

i used the expression as

=((count({<PAID DETAILS={'NOTNULL'}>}PAYING_WAY))/(Count({<PAID DETAILS={'NULL'}>}PAYING_WAY)+

Count({<PAID DETAILS={'NOTNULL'}>}PAYING_WAY)))*100

can i any one help for the gauage chart

[manoranjan_d]

i tried to remove the 100 in the expression but it showing incorrectly display of the gauage , but diaplying the 55.55% is perfect in presentastion tab

[manoranjan_d]

if amount was huge like million and billions

[sunny_talwar]

You can do an if statement:

If(Sum({<PAYING_WAY = {'BANK'}>} AMT) > 1000000000,

          Num(Sum({<PAYING_WAY = {'BANK'}>} AMT)/1000000000, '$#,##0.0B'),

If(Sum({<PAYING_WAY = {'BANK'}>} AMT) > 1000000,

          Num(Sum({<PAYING_WAY = {'BANK'}>} AMT)/1000000, '$#,##0.0M'),

If(Sum({<PAYING_WAY = {'BANK'}>} AMT) > 1000,

          Num(Sum({<PAYING_WAY = {'BANK'}>} AMT)/1000, '$#,##0.0K', '$#,##0.0)))