How to show % values using class function

[#1]

Hi,

i need  to show  in the class  function the values in % like 10% <=x< 20%.

The formula that I use is:

=class(round(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)

/

count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale), .1), .1)

I got the values like 0.1<=x<0.2 and so on.

Any idea?

Thanks!

Andrea

[#2]

Hello,

You can use the num() function, with your own number format (here, the %).

num( 
class(round(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)
/
count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale), .1), .1)
,'# ##0%')

Regards,

Amand

[martin59]

Hi,

Amand was on the right way,

But to be sure on your numeric format, I advise you to enter the last parameters (decimal and thousand separators) like this :

num( 
class(round(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)
/
count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale), .1), .1)
,'#,##0.%','.',',')

Hope that helps you,

Martin

[#4]

Hi,

better but not as I want to have. I got only one value 80%, 70%, etc. not 80%<=x<90%.

Any more idea?

Thanks!

[martin59]

However,

You have to do this :

floor(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)
/
count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale), .1)
& ' <= x < ' & 
ceil(aggr(count({<ID_FactSource={'ARIANNA'}>}distinct ID_FAT_DATA_FILE)
/
count({1<ID_FactSource={'ARIANNA'}>} distinct total ID_FAT_KEY_FILE), ID_FAT_C_Committente_Originale)+0.1, .1) as MyField

Hope that helps you,

Martin