0

Very simple excel formula not translating across to Ninox... what am i doing wrong?

Hello All

I need to calculate the trade price of an item based on the shop margin. In excel i use the formula:

RRP * (100% - shop margin)

But i can't seem to replicate this in Ninox. Any ideas??

Many thanks

Ben

4 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Please post your the code you have written so far.

      • Earthsong Seeds
      • Ben_Heron
      • 2 yrs ago
      • Reported - view

      Fred 

      Hi Fred, the only code i have written so far is as above:

      RRP * (100% - 'Assumed shop margin')

      But that doesn't work. I'm sure the solution must be very simple!

    • Fred
    • 2 yrs ago
    • Reported - view

    Ninox doesn't do %. Unless they've added that feature. I haven't checked recently. So if 'Assumed shop margin' is a decimal then:

    RRP * (1 - 'Assumed shop margin')

    or if 'Assumed shop margin' is an integer then:

    RRP * ((100 - 'Assumed shop margin')/100)
      • Earthsong Seeds
      • Ben_Heron
      • 2 yrs ago
      • Reported - view

      Fred That works perfectly. Thank you so much 🙏

Login to reply

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 4Replies
  • 51Views
  • 2 Following