Forum Discussion
Need help with manually calculating difference between two percentage or numbers and cond. formattin
Hello ,
Thanks for checking. I tried and its not working.
My requirement is in Jan percentage is 83.83 and Feb is 85.07 i want the difference between two (85.07-83.33). Kindly help. Thanks in advance for your help
Hi,
It was not indicated on your first post that you need the percentage value difference.
Anyway, i had no idea how the Total Resolved % is claculated.
but if this is what you want to achieve,
use the previousmonth function for the % and the subtract them
Resolved % LM =
CALCULATE(
[RESOLVED %],
PREVIOUSMONTH('Table (2)'[Date]),
REMOVEFILTERS('Table (2)'))
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
Hi aravind2409 ,
"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 %
mussaenda Kindly help sir.
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 %
Thank you sir.
