Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))))
Hi Rajesh,
I find out, that INPUTSUM doesn't work with any IF-statement, by using '*' or '+' etc. too.