Inputsum Calculation

[#1]

Hi,

I need to some feedback in using INPUTSUM function. I am using "inputsum" in a pivot table. The below expression works fine..

INPUTSUM(KPI_INPUT) where i defined KPI_INPUT as input field in my script.

If i add sum condition in inputsum then it is not working. For eg.

INPUTSUM(IF(DATA_TYPE='D',NUM(KPI_INPUT,'####0'),IF(DATA_TYPE='F',NUM(KPI_INPUT,'####0.00'))))

[brenner_martina]

Hi Rajesh,

I find out, that INPUTSUM doesn't work with any IF-statement, by using '*' or '+' etc. too.