Question

[#1]

Hi,

I have a data set with two fields i.e the Budget and amount spent from the budget. i need to calculate the percentage of the total expenditure. how do I create the function.

Actual Budget - Combined	Consumed Budget                                                                      Combined
$32,500.00
$1,140.00
$192,708.00
($99.69)	($99.69)
$48,853.78	$16,353.78
$325.00	$325.00
$935.38	$935.38
$8,765.37	$8,765.37
$206,579.83	$207,332.13
$13,330.51	$13,330.51
$0.00	$0.00
$100,000.00
($96,354.00)
$0.00	$0.00
($56.00)	($56.00)
$99.69	$99.69
($1.71)	($1.71)
$98.56	$98.56
($6.96)	($6.96)
$27,162.03	$27,162.03

[OmarBenSalem]

sum("consumed Budget")/sum(Budget) and format it as % ?

[#3]

how do i format into percentage

[vinieme12]

NUM(EXPRESSION  , '##.##%')

[OmarBenSalem]

Depends ! If It's a text object, do as Vineeth suggested. If it's any other chart, you can do it as follow:

under data, your measure: