Formula in Custom Report

Apr 20, 2005 1 Replies

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


Formula is only a SQL field..

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

SQL syntax: SELECT SUM(delta) as DELTAsum

Antonio

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required