I am adding this formula to GST/HST field. I have a picklist (Province_for_tax_calculation) with values ON,BC,NB etc.

I have another field called Amount Payable which needs to be calculated based on the picklist value selected. The formula below is not working. Any ideas?

IF(
OR(
ISPICKVAL(Province_for_tax_calculation__c, "ON"),
ISPICKVAL(Province_for_tax_calculation__c, "BC"),
ISPICKVAL(Province_for_tax_calculation__c, "NB"),
ISPICKVAL(Province_for_tax_calculation__c, "NS"),
ISPICKVAL(Province_for_tax_calculation__c, "NL"),
ISPICKVAL(Province_for_tax_calculation__c, "PEI"),
ISPICKVAL(Province_for_tax_calculation__c, "QC")),
"Amount_Payable__c *0.13,0",
"Amount_Payable__c *0.12,0",
"Amount_Payable__c *0.13,0",
"Amount_Payable__c *0.15,0",
"Amount_Payable__c *0.13,0",
"Amount_Payable__c *0.14,0",
"Amount_Payable__c *0.149,0"
)

Is there a way in Salesforce reports to specify a date range from a particular date to TODAY?

e.g. I want the report's end date to always be replaced with today's date e.g. 2/13/2012 to TODAY. I really need an answer on this please. Can someone help me?

Is there a way in Salesforce reports to specify a date range from a particular date to TODAY?

e.g. I want the report's end date to always be replaced with today's date e.g. 2/13/2012 to TODAY. I really need an answer on this please. Can someone help me?