Forum Discussion
Need help with manually calculating difference between two percentage or numbers and cond. formattin
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 %
mussaenda its not working. i have shared my formulas kindly check and help. am sorry if am bugging you
