Forum Discussion
Post Prodigyan argument of function power has the wrong data type
hi all , the calculate are repeatedly good with Others , but when it comes to this one , it shown like this ,
it happens only with this formula , while CAGR2021Vs. 2019 and the rest are working normal , and i used the same things.
and it happened only with NSR when i change filter to Volume ,it looks okay , how to settle this ?
Hi Chanleakna123 ,
Use the formula below:
Check = IF(Val = BLank(),BLANK(),IF( Val<=0,"novalue",(Val^(1/2))-1))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
7 Replies
- amitchandak
Super User
Chanleakna123 , is it possible that val^(1/2) is not possible for some value. Check the possible value of val. Also, check by removing this that is this causing a problem
I think blank many causing it make it 0 in place of blank in divide
- Chanleakna123
amitchandak , can you recommend me , which formula that it should be right over this ?
since , it this is CAGR formula, therefore the formula looks like this
- Greg_Deckler
Community Champion
Chanleakna123 - If Val in your formula ends up negative, you will get that error.
- Chanleakna123
Greg_Deckler , you're right , i have negative volumn in the chat , that is why , so how to do it ?
v-deddai1-msftCommunity Support
Hi Chanleakna123 ,
This is a mathematical logic problem. Negative numbers cannot calculate with ^1/2. If you really need the value, just add ABS before val like: ABS(val).
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
