FavoriteKel Hill asked in #Data ManagementAug 22, 2019, 10:05 AMNeed to multiple a monthly dollar value by the number of months that have passed in the current year in a formulaHow do I bring the current YTD month count into a formula? I need a variable that means 8 in August, 9 in September. I am trying to multiply a monthly price to get YTD revenue within a formula. Any help appreciated!2 answersSortSort by DateSort by Most HelpfulSort by DateLoad more comments...Accepted AnswerEric Praud (Polsource)Aug 22, 2019, 10:13 AMTry this (where Monthly_Price__c is your field): MONTH(TODAY())*Monthly_Price__cAdd a commentWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Accepted AnswerEric Praud (Polsource)Aug 22, 2019, 10:13 AMTry this (where Monthly_Price__c is your field): MONTH(TODAY())*Monthly_Price__c
