QuickBase Pretty Print
Input
If(( ToDate( [Requested Start Date Time]) <= ([Report Start + 30]+Days(31))and ([Reporting Start Date]+Days(31))<=ToDate([Requested Finish Date Time])), If(([Requested Finish Date Time]=[Requested Start Date Time]),[Weighted Forecast],[Days in Billing Period 30-60]*[Weighted Forecast Daily Amount]), If((IsNull([Requested Start Date Time]) or IsNull([Requested Finish Date Time])) and [Estimated Sale Close Date - Service]>=[Reporting Start Date]+Days(61) and [Estimated Sale Close Date - Product]<=[Reporting Start Date]+Days(90) and [Estimated Sale Close Date - Product]>=[Reporting Start Date]+Days(61) and [Estimated Sale Close Date - Service]<=[Reporting Start Date]+Days(90),[Weighted Forecast],0))
Auto Update
About
This is a syntax highlighting and pretty printing app for QuickBase Formulas the syntax of which is described on
QuickBase Help
.