Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Infinity Value appears even though a Value should appear

I'm trying to get the converted currency Cost in Sterling by using a vlookup from my currency file as follows:   Cost Price GBP = If(Products[Cost Price Currency]="GBP",Products[Cost Price],Produc...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try like

Cost Price GBP = If(Products[Cost Price Currency]="GBP",Products[Cost Price],
divide(Products[Cost Price],LOOKUPVALUE('exrates-monthly'[Currency units per £1 ],'exrates-monthly'[Currency Code],Products[Cost Price Currency]))

)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amitchandak

 

This works perfectly and gets rid of the infinity symbol thank you!