Calculating Fees in a chart-

[#1]

Hi All,

im trying to add multiple fees. I use this expression

RangeSum((Cardfee),(technologyfee),(spacefee),(depositamount),(Extrafee))

but this only works if i select one dimession or field. HELP!@!!!!!!!!

[deepakk · Accepted solution]

hi,

You requirement is not clear, can you attach a sample file.

Did u try the below codes

Sum(Cardfee +  technologyfee +  spacefee + depositamount+ Extrafee)

or

Sum(Cardfee)+ Sum(technologyfee) + Sum(spacefee) + Sum(depositamount)+Sum(Extrafee)

Deepak

[#3]

i try this but it doesn't work.

i have numerous Purchase Order (PO) and some of the Fees are 0 which makes my formula work only if i select one PO or there are no 0. HELP

[deepakk]

hi,

Can you attach the application or send some sample to data to check.

Deepak

[Anonymous]

hey hi

u can try isnull function n set fee as 1 if some fees are cuming 0.

vaibhav

[Anonymous]

hi Jafreisy,

               Did ur problem resolved?

[#7]

i was trying sum at the begining and not the sum of each. Thanks all! 😉