Forum Discussion

aravind2409's avatar
aravind2409
New Member
3 years ago

Need help with manually calculating difference between two percentage or numbers and cond. formattin

Hi All,   I have a data like this. Need help with subtracting Jan - Feb and Feb - March like wise and show the difference. Kindly help this is bit urgent. Would be great if some one can help on thi...
Need Help
aravind2409's avatar
aravind2409
New Member
3 years ago

Thanks for taking time and considering my query. Let me share my formulas fully.

Here is the details:

Previous Month:

Resolved Count:

 

 

Please advice on my output. I tried with your earlier suggestions its not coming 

 

I am requesting your help kindly. Thanks and this is bit critical to complete the automation. I am sorry if am bugging / troubling you

  • mussaenda's avatar
    mussaenda
    Community Champion
    3 years ago

    Hi aravind2409 ,

     

    i responded to you.

    Please check the replies

     

    "My requirement is in Jan percentage is 83.83 and Feb is 85.07 i want the difference between two (85.07-83.33)"

     

    according to your  requirement, test1 is correct, right? you just need to change the data type  to %

    • aravind2409's avatar
      aravind2409
      New Member
      3 years ago

      mussaenda  its not working. i have shared my formulas kindly check and help. am sorry if am bugging you