LinkBack URL
About LinkBacks
Try
in "OT"
im M2
=SUM((([@[Monthly Base]]+[@Shift]+[@Stipend])/173.333)*IF([@[Earn ID]]="OTPR",1.5,1))
in "STIPENDS"
in N2
=SUMPRODUCT((Stipend_Type[Amount])*(Stipend_Type[Stipend Type]=Stipends[@[Stipend Name]:[Special Assignment 3]]))
Try
in "OT"
im M2
=SUM((([@[Monthly Base]]+[@Shift]+[@Stipend])/173.333)*IF([@[Earn ID]]="OTPR",1.5,1))
in "STIPENDS"
in N2
=SUMPRODUCT((Stipend_Type[Amount])*(Stipend_Type[Stipend Type]=Stipends[@[Stipend Name]:[Special Assignment 3]]))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks