4 Replies Latest reply: May 16, 2017 6:06 AM by omar bensalem

# Question

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
• ###### Re: Question

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

• ###### Re: Question

how do i format into percentage

• ###### Re: Question

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

• ###### Re: Question

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