KPI + SUM function to add multiple fields

[bansefi01]

I have multiple fields that need to be added in a KPI, how can this be solved ?

Sum ([Monto TP (punto fijo)],[Monto TP (punto temporal],[Monto TDD])

thanks

[sunny_talwar]

May be this

RangeSum(

Sum([Monto TP (punto fijo)]),

Sum([Monto TP (punto temporal]),

Sum([Monto TDD])

)

[bansefi01]

thanks

[bansefi01]

Thanks a lot, i used it and it works perfectly

Wondering, is there a way to have SUM function for diferent fields with same name begin?

something like this

RangeSum(

Sum( {$} [<="punto*">]

Expected result should be the sum for all data fields with the same "punto" begin string

Thanks

[sunny_talwar]

You should be able to use The Crosstable Load and then convert your fields into a column then use set analysis to do this....