We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 45950
    • 40 Posts
    Just getting the hang of xpdo... smiley

    Could someone lead me in the right direction for info on creating/using mathmatical based queries and output from tables?

    A couple things I'm trying to accomplish...

    • add up sales to output total
    • days to expiration: current date minus start date = days left to expiration
    • goal minus sales = percentage achieved (ultimately in a graphical form eg. progress bar) if this % equals this then show this.

    And a shout out to the helpful folks here on the forum (you know who you are)... A great bunch and very knowledgable. My hat is off to you! So glad I discovered MODX!
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      You might want to look at something like the MiniShop2 extra and see how they did it.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org