Almost there, but i think I've lead you astray a little.
When i wrote size, that is actually a field I'm using rather than a function. Apologies for the confusion. Perhaps we should use [Ship Size] for this exercise.
It worked when i put a basic formula in at the end (such as 5*12) but I still can't get the above formula to work with my tinkering.
Question - is SIZE an existing field or the function, SIZE()? @Rajeev Pandey < I suspect its an existing field, not the function, more below.
I assume its an existing field, and therefore assume the issue with your calculation is that Size is a String rather than a Integer.
Does it look like this?
If so Tableau is trying to do something like this - 5*randomtext^12 < hence the error.
Right click SIZE and Change Data Type swap to Integer (Number)
Your calculation should now work.
PS. There is a POWER function.
Why I think that's going to work... In Superstore Sales is a Number/ Measure.
When i wrote size, that is actually a field I'm using rather than a function.
Try my suggestion... Sorry crossed over with your reply.
I was originally using the field in my initial attempt - see the [ ].
Whilst fiddling, I scrapped and re-wrote the original to try and match your valid calculation and somehow it worked. I've no idea what i was doing wrong the first time but got there in the end!
Thank you both for your help!
Sorry I misunderstood the situation!!