hi,

i write the below code and after i saved the formula the type is coming as 'Boolean' (True/False) actually i need the result if "Active" my Aquision cost should appear and "NonActive" the amount need to be zero. my output come as number not Boolean. how to change it. please advice
if cstr({view_FA_Depreciation_Yearly.Asset_Status})="Active" then
tonumber({view_FA_Depreciation_Yearly.Acquisition_Cost})=tonumber({view_FA_Depreciation_Yearly.Acquisition_Cost}) else
tonumber({view_FA_Depreciation_Yearly.Acquisition_Cost}) = 0