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% )

All responses (5)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

Management report

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
CU28091606-0 25 on at

Like (0)

Report

Management report

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.
CU28091606-0 25 on at

Like (0)

Report

Management report

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 ?
Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

Management report

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

BillurSamdancioglu 15,786 Most Valuable Professional on at

Like (0)

Report

Management report

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?