Forum Discussion
Helper VRow wise calculation in percentage
Community Championnevermind, 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
Helper V- 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! 🤠
- NadeemAhamed
Thank your suggestion.
Requirement:
From sales dept i will receive only Plan and Actual values for category and division wise.
1. I have to calculate Variance(Actual - Plan) and Achievement (Actual/Plan) Values in seprate column, that is resolved.
2. I have calculate "Gross Profit Rate" value from "Gross Profit/Sales" and have to place after Gross Profit Row to pertcular Plan, Actual, Variance and Achievement Columns in percentage.
3. When we are selecting multiple division "Gross Profit Rate" value should not get sum, it should be take the current "Sales and Gross Profit" values for calucation.
- Daniel29195
Kindly check the below
https://drive.google.com/file/d/1wDjBlJuGmvsVFyctYWJH9JuaRNrjoEsk/view?usp=sharing
let me know if this works for you .