Hello all,
I am trying to create an Actual Gross Margin % in the Project Module. I tried the first part and it correctly calculates the Gross Margin $. And the second part correctly shows the Actual Revenue.
=(iif((PMBudget.Type] = 'I',,PMBudget.CuryActualAmount],0) - iif((PMBudget.Type] = 'E',,PMBudget.CuryActualAmount],0))
/
(iif((PMBudget.Type] = 'I',,PMBudget.CuryActualAmount],0))
But when I put the divide sign in between it returns rubbish.
I am relatively new to GI and am struggling to understand where I am going wrong.
Any guidance would be most gratefully accepted.
Cheers,
Andrew
