an argument of function power has the wrong data type

[Chanleakna123]

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 ?

[Greg_Deckler]

@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-msft]

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

[Chanleakna123]

@v-deddai1-msft  , yes i have perform this one 🙂 . but it sounds not righ 😞

since we turn Negative to Positive Number. 😞 

thx you 

[v-deddai1-msft · Accepted solution]

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

[amitchandak]

@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