Hi All ,

I am stuck in Challenge 5 of Trailmix #2 #Trailmix2superbadge. 

Ask: Create report column , Adjusted Expected Revenue, that shows what happens to expected revenue if the analyst is correct. This column should show a currency value 10% higher at the Subtotal and Total levels if the account has at least one SolarBot, and the original value if not. Don’t create any new fields.

For the above issue, i created a summary level Formula column with the same name. Changed "Format output Type" to Currency and kept decimal points as 2 and provided the below formula for the above statement

IF(Account.Number_of_SolarBots__c:SUM > 0, EXP_AMOUNT:SUM * 1.1, EXP_AMOUNT:SUM)

After Applying it, i could see that the value is not showing as Currency format. When i go back to the formula field for edit , the "Format Output Type is again showing as Number.

I think because of this i am getting below error message 

"The settings for the 'Adjusted Expected Revenue' column aren't correct."

Please help me resolve this.

#Journey2Salesforce 

Regards,

Prajeesh Karat