Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Looking for help please to produce an excel formula for a finance assessment spreadsheet.
Based on income calculations I need to formulated capacity but it is based on the below:
##If (centrelink income(b17) + centrelink deductions(b18) are higher than the combined total of (wages(h17) + salary sacrifice(h18) + other(h19)) then capacity is 20% of centrelink + centrelink deductions + wages + salary sacrifice + other.
##If (wages + salary sacrifice + other) are higher than the combined total of (centrelink income + centrelink deductions) then capacity is 40% of centrelink + centrelink deductions + wages + salary sacrifice + other.
###Both of the above "if's" have to apply to total income (e20) based on whether the income is weekly, fortnightly, monthly or 90 days at (i20).
My email is gavin.roymcleod@gmail.com I can email spreadsheet if you can help. Please contact me on my email.
I hope someone can help please.
Centrelink (b17)
Centrelink deductions (b18)
Wages (h17)
Salary sacrifice (h18)
Other (h19)
Capacity (i62)
Weekly, fortnightly, monthly, 90 days drop down box (i20)
Hi @Macca ,
Is this calculation to be made on power query or power pivot? or a simple excel spreadsheet?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |