^ or Power() in update data expression | Community
Skip to main content
Idde1969
February 15, 2019
Solved

^ or Power() in update data expression

  • February 15, 2019
  • 1 reply
  • 1506 views

Hi.

I am trying to update a field with data using either ^ or the Power() funtion.

Floor(Random() *  2 ^ $(vars/@varNoOfGroups))

Genertates a GUI error and

Floor(Random() *  Power(2, $(vars/@varNoOfGroups)))

Generates an error in the Journal

2019-02-15 10:54:12 writer XTK-170016 You are not authorized to use SQL expressions. 'Power' cannot be processed.

Any clue on how to solve this. Tried to add the named right SQL SCRIPT EXECUTION to my user

Best regards,

Martin

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

Follow this guide:

Thanks,

-Jon

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
February 15, 2019

Hi,

Follow this guide:

Thanks,

-Jon