code error

[Anonymous]

Hello, I have been trying to figure this out for the past half hour - why is the function code in black? Please see screenshot below:(notice that the sum is black instead of blue?

Please advise, thanks!

W

[#2 · Accepted solution]

enclose within square brackets

=pow(sum([Current QTD Sales])/sum([Previous Sales]),1/30)-1

[#3]

Hi Ramkumar

pow process try

pow(x,y)

=pow(sum([Current QTD Sales]) / sum([Previous Sales]),(1/30)-1)

reds

rudra

[sujeetsingh]

This thread should be marked as answered

[Anonymous]

Hi, i think they should work. I havent tried yet, it's my morning here.

Thanks!

[#6]

If you are trying to reference a field with spaces in between them you should enclose the field with [ ]'s.

As shown above.

Regards,
Marius

[Anonymous]

Hello... something is still not right.. I am getting null even though they are numbers in both fields... why is that?

Thanks!

W