Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

InputSUM expression

Dear community,

Attached herewith a sample document, the expression as shown below is not working.

FY column :

=if(Column(3)>0, inputsum(FY))


How could i get the yellow highlighted line only?

Thanks,

Chanel

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You are right, I missed a small thing. PFA

View solution in original post

4 Replies
tresesco
MVP
MVP

May be like attached sample

Not applicable
Author

Appreciate your prompt response,

may i know why the min become 1?

It should be 0...

Thanks,

Chanel

tresesco
MVP
MVP

You are right, I missed a small thing. PFA

Not applicable
Author

Awesome! Thanks for your kindly help!