Forum Discussion
Helper VRow wise calculation in percentage
Community Champion
Hello Nadeem,
can you show an example of the desired result , ( in excel per example ) .
cause im not sure i quite understand the problem with calculating (Gross Profit/Sales) since you already calculated the Variance and Achievement column
best regards
Helper VDear Daniel29195 Sir,
Good Day.
Thank you for your valuable time to read and reply my post.
As i understood your question u want to see the example how i am calculating the difference in excel sheet, Is It right?
- Daniel29195
nevermind, my bad, didnt focus on the image you have attached.
i got what you want 😅
give me some time and i will send you the solution .
best regards
- NadeemAhamed
- Daniel29195
link:
https://drive.google.com/file/d/1gxq7LrYwLHp0_o9owqj3g3mVO9GNAyza/view?usp=sharing
kindly check the above link and download the solution.
summary :
creating measure which check if category = " gross profi rate" , it uses format function to format the value as % ) .
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠