Share
Report
5Hai , 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 ?
Categories:
All responses (
Answers (
