KX Community

Find answers, ask questions, and connect with our KX Community around the world.

Home Forums KX Academy Fundamentals Capstone 5.2 format test fail.

  • Fundamentals Capstone 5.2 format test fail.

    Posted by Kenan on April 2, 2024 at 7:35 pm

    I’m having an issue witht the format for 5.2, my code for 5.1 and 5.3 pass… I attached a copy of my code and the schema for edgeProfile.

    edgeProfile: select numTrds: count i, avgEdge: avg edge, minQty: min qty, maxQty: max qty by option_id from trade where date = last date, edge > avg edge

    Laura replied 1 month, 1 week ago 3 Members · 3 Replies
  • 3 Replies
  • Kenan

    Member
    April 3, 2024 at 7:19 am

    I found why my test was failing. Thank you

  • Kal8na

    Member
    April 13, 2024 at 6:56 am

    I’m getting the same error can you explain what is wrong here please?

  • Laura

    Administrator
    April 15, 2024 at 4:22 pm

    Hi @kal8na,

    I’m not sure without looking at your code, but for 5.2 you will need to ensure you are using fby or similar. You can watch this video to get a better idea of how to approach this: Fby Vs. Nested Queries – KX Learning Hub

    Hope this helps,

    Laura

Log in to reply.