Num function formatting on Gauge chart

[mandilicious]

Hi Champs

I am using below expression in my Gauge chart which works fine cause i am getting correct results.

My problem is to format value according to the clients

Totals value is =0.00002337 then client need to see only 2 not 0.02 etc  cause i used many Num FUNC last one was '#%' then i get 0.02 .how to can i omit the first  5 zeros to get 2 as value?

=num((count({$<campaign_id={"tech","service"},term_reason ={"ABANDON"}>}lead_id)/100)

/

count({$<campaign_id={"service","tech"},user_group ={"NEO"}>}phone_number),'#%')

Thanks

[sunny_talwar · Accepted solution]

May be multiply by 100?

[mandilicious]

Hi Sunny

I used * 100 in  below it seems to be working

=num((count({$<campaign_id={"tech","service"},term_reason ={"ABANDON"}>}lead_id)/100)

/

count({$<campaign_id={"service","tech"},user_group ={"NEO"}>}phone_number)*100,'#%')

Thanks

[mandilicious]

Hi Sunny

I thought by using '#%' solved formatting function but after i refreshed my dashboard today is still show 0.8 instead of only 8%

,

[sunny_talwar]

Try this

=num((count({$<campaign_id={"tech","service"},term_reason ={"ABANDON"}>}lead_id)/100)

/

count({$<campaign_id={"service","tech"},user_group ={"NEO"}>}phone_number)*100,'##.%')

[mandilicious]

Hi Sunny

Thanks,after using '##.%' i am getting 0.

[sunny_talwar]

What if you multiply by 1000 instead of 100

[mandilicious]

Hi Sunny

It worked if i may ask why we multiply by 1000 instead of 100 ?

[sunny_talwar]

Because it seems that you number was showing up as 0.008 and to make it 0.08, we had to multiply it by 1000 instead of 100

[mandilicious]

Sunny you are the best Thanks