Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear team
Below I have mentioned a formula where I am dividing one formula with another formula. There is one condition is MonthNMum-='01'. Can we change the formula where I will use MonthNum only one time
=(Sum({<[Exec P&L Heading] = {'Gross Profit'},MonthNum={'01'} ,Year ={$(=max(Year))}>}Amount)*-1)
/
(Sum({<[Exec P&L Heading] = {'Revenue'},MonthNum={'01'} ,Year ={$(=max(Year))}>}Amount)*-1)
I need formula something similar to mentioned below.
MonthNum='01" then (Sum({<[Exec P&L Heading] = {'Gross Profit'},Year ={$(=max(Year))}>}Amount)*-1)
/
(Sum({<[Exec P&L Heading] = {'Revenue'},Year ={$(=max(Year))}>}Amount)*-1)
BR
SHamsu