Management reporter formulas

(0) Share

Report

Posted on by Community Member

Hello,

I need to know how I can do this formula in the MR rows:
Row 100: Sum of 2 accounts
Row 101: Sum of 1 account
Row 102: If row 101> 0 then row 101 but 0
Row 103: Row 100 + 102

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Frank_Heslin 895 on at

Like (0)

Report

I'm not sure what you meant for Row 102 so I guessed;-) Also, I haven't tested this so I hope it works, and is what you need.

For Rows 100, 101, & 103 the formula is straightforward.

Row 102 could get a little tricky.

Let us know if it works.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Row 102: If the result of row 101 is greater than 0, show me the value of row 101, otherwise it shows 0.

Thanks!

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

Question - Nathaly, do you want 101 to show in the report - or do you just want to see 103 ? Which appears to be the end result.

Just wondering as I have a similar issue and it was great to see someone else ask the question.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I just want to see row 103.

Was this reply helpful? Yes No
Suggested answer

Frank_Heslin 895 on at

Like (0)

Report

For any row that you don't want to print, you can enter NP in column 'G' (Print Control). There are some things to consider though. For example if you want a non-printed row to be included in calculations, you have to refer to the row(s) number(s) directly. (100+101+102; NOT 100:102) I suggest looking up Advanced Formatting Options, and go down to Select Print Control in a Row Definition for specifics.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

My specific question is how to make the condition of row 102.

Thanks!

Was this reply helpful? Yes No
Suggested answer

Frank_Heslin 895 on at

Like (0)

Report

I tested it, and got the results that I expected. In my original reply I didn't have the @ sign before the 2nd 101.

I entered this:

And these are the results: (Row 102 is set to not print)

Try this and let us know if you get the desired results.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It does not give me the same result, the columns are set so that the time of the balance of the period with the opening balance.

Was this reply helpful? Yes No
Frank_Heslin 895 on at

Like (0)

Report

Can you post a screen shot of the Row Definition?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Row 370 represents row 100
Row 385 represents row 101
Row 397 represents row 102
Row 399 represents row 103

Thanks!

Was this reply helpful? Yes No