Case 942 How to make the display in % ?

[paulyeo11]

Hi All

I have below expression , it will return 0.25 , May i know how to make it return 25%

(sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)))-sum(DISTINCT $(=only({<[Pls select 61st Dim],Column61={'Cost'}>}Column61)) ))/
sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)))

Below link is my QVW :-

https://www.dropbox.com/sh/bia6w7ucbre6zqu/AABa1TEyJhpCGsNZxlUipqtsa?dl=0

Paul Yeo

[Kushal_Chawda]

@paulyeo11  check below option

[paulyeo11]

Hi Kush

I cannot use the Number setting , as it will make all result display as % , as my result need to be dynamic , due to my expression :-

=pick(Match([Pls select 61st Dim],

'Ave_SQ_Amt',
'Total_SQ',
'Total_Amount',
'Total_Cost',
'Total_GP',

),
sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)))/count(DISTINCT $(=only({<[Pls select 61st Dim],Column61={'DocNum'}>}Column61)) ),
count(DISTINCT $(ColumnDim61)),
sum($(ColumnDim61)),
sum($(ColumnDim61)),
(sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)))-sum(DISTINCT $(=only({<[Pls select 61st Dim],Column61={'Cost'}>}Column61)) ))/
sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)))

)

Paul

[Vegar]

Use formating function  Num() around your expressions. For the percentage expression use num(<expression >, '0%')

[paulyeo11]

Hi Vegar

I have try below , it does not work :-

num(sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)))-sum(DISTINCT $(=only({<[Pls select 61st Dim],Column61={'Cost'}>}Column61)) ))/
sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)),'0%')

[Kushal_Chawda · Accepted solution]

@paulyeo11  try below expression

num((sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61)))-sum(DISTINCT $(=only({<[Pls select 61st Dim],Column61={'Cost'}>}Column61)) ))/
sum($(=only({<[Pls select 61st Dim],Column61={'Total'}>}Column61))),'#0.%')

Also, make your expression setting in Number tab as "Expression Default"

[ramchalla]

Hi Paul,

you can try the below.

Num(<Expresssion>, '#,##0%')

[paulyeo11]

Thank you very much , it work fine.