Finance | Project Operations, Human Resources, ...

Management report

(1) Share

Report

Posted on by CU28091606-0

Hai , I have Created Column definition to get Percentage of Variance between two months and the Column definition as shown below. My Issue is when I take the Report am getting wrong percentage. if the current month having an amount and the Previous month is ZERO. Eg : January is '0' and February is 200000 , Then Jan to Feb Variance is showing 40,000,000,100.00 and if January is '0' and February is 68052.02 then its showing 0%. its work only if both month having transaction. Any one could suggest what type of Formula I need to use to correct this ?

When I am missing either a numerator or denominator it suppose to show either 100 % or (100% )

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

BillurSamdancioglu 20,827 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Do you see these values when you export to Excel?

Why the first line shows zero different?

May that be because of the excel field type?

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,631 Moderator on at

Like (0)

Report
Copy link

Link copied!

What value do you want it show when you are missing either a numerator or denominator?

Was this reply helpful? Yes No
CU28091606-0 61 on at

Like (0)

Report
Copy link

Link copied!

If one of the month is '0' , then the Percentage will be either 100% or (100)%. and why the second line shows as wrong Percentage ?

Was this reply helpful? Yes No
CU28091606-0 61 on at

Like (0)

Report
Copy link

Link copied!

why system is calculating wrong Percentage ? January one transaction is with Project and another transaction is without project and in Total January is '0'. but in management report its showing as different and percentage calculation also shows as wrong.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,631 Moderator on at

Like (0)

Report
Copy link

Link copied!

I can't explain the 40,000,000,100.00 value but for the other rows where you're either dividing by zero (blank) or dividing a zero (blank) by some number, those aren't valid mathematical operations. Have you looked at using either of these settings?

Report level

Column level

Was this reply helpful? Yes No