Infinity Value appears even though a Value should appear

[Anonymous]

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],Products[Cost Price]/LOOKUPVALUE('exrates-monthly'[Currency units per £1 ],'exrates-monthly'[Currency Code],Products[Cost Price Currency]))

However, I've noticed some infinity values with some records where there should have been a value as there is a Products[Cost Price] against these infinity records.

How do I go about getting the actual value for these records instead of the infinity sign?

[amitchandak]

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

Hi @amitchandak

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

[Anonymous]

Hi Have you tried DIVIDE in your calculation?

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

[Anonymous]

Hi @Anonymous ,

The syntax you've provided below is comming back with errors, how can I write this formula using the DIVIDE function?

Many thanks