Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

^ or Power() in update data expression

Idde1969
Level 1
Level 1

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

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor
1 Reply
wodnicki
Correct answer by
Community Advisor
Community Advisor