+ Start a Discussion
Imtiaz PashaImtiaz Pasha 

Hi All i want to create formula for this please help me out below are the details


CASE( Name , "Design Finalization", Project__r.Amount__c /20, "Complete Design Sign-off",Project__r.Amount__c /55 ,1).
This is my current formula, i want to change from that to this below :
Kindly help me out.


logic to calculate the milestone amount in the payment milestones:

If { milestone name = Design finalization, Milestone Amount == (Project value * 20%) - Opportunity's Invoice Amount;
Else If { Milestone name = Complete Design Sign-off, Milestone Amount == (Project value * 55%) - (Opportunity's Invoice Amount + Design Finalization's Invoice Amount);}
Else If {Milestone name = Factory Dispatch, Milestone Amount == Project value  - (Opportunity's Invoice Amount + Design Finalization's Invoice Amount+ Complete Design Sign-off's Invoice Amount);}}


Attributes:
Milestone name = Project__r.Name
Milestone Amount = EligibleAmount__c
Project Value: Project__r.Amount__c
Opportunity's Invoice Amount = Project__r.Opportunity__r.Amount  / 20
Design Finalization's Invoice Amount = Project__r.Total_Amount__c
Complete Design Sign-off's Invoice Amount = Total_Amount__c
Imtiaz PashaImtiaz Pasha
any one on this help out