You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Narrative Reporting Formula - Ignore negative values in sum

Hi, In narrative reporting I have a number of conditional suppressions in my report for negative values. I am trying to only sum the positive values for a certain range of rows and would like to ignore any negative values in my sum. I am using a custom formula and have the following formula:
[2]+[3]+[5]+[7]+[8]+[9]+[10]+[31]+[32]+[33]+[34]+[35]+[36]+[37]+[38]+[39]+[40]+[41]

If rows 31 - 40 are negative, I would like to ignore in my sum.

Thanks for your help in advance!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!