Formula in Custom Report

I'm somewhat new to retail management system. I have a Commision column I want to have calculated differently based on which day of the week is. I have a date column that I should be able to get the day from but I don't know how this is done. Maybe someone can give me a link to good documentation about using the Function="" area and what can go in it. Thanks!!

Eric

Reply to
Eric
Loading thread data ...

Formula is only a SQL field..

FieldName = 'DELTAsum' Formula = "SUM(delta)"

SQL syntax: SELECT SUM(delta) as DELTAsum

Antonio

Reply to
Antonio Mazzeo

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.