Amount * Rate = SGD Amt Wrong

[Paulyeo11]

Hi All

I have below expression :-

AR_AMT_SGD =

if(divide([SALES_],'RATE'[_rate]) =0 , blank(),divide([SALES_],'RATE'[_rate]))

Above expression return wrong amount :-

What i want is AR_AMT_ X _rate= AR_AMT_SGD

https://www.dropbox.com/s/cgzsp911xj3sr1v/Testing3.pbix?dl=0

above is my PBI file.

Paul

[Fowmy · Accepted solution]

@Paulyeo11 

Try one of the following, not sure if you need to multiply or divide:

AR_AMT_SGD = [AR_AMT_] * [_rate]

AR_AMT_SGD = DIVIDE([AR_AMT_] ,  [_rate],BLANK() )

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[PC2790]

Hi @Paulyeo11 ,

If you want AR_AMT * _Rate, then shouldn't the formula be:

AR_AMT_SGD =

if(divide([AR_AMT ],'RATE'[_rate]) =0 , blank(),divide([AR_AMT ],'RATE'[_rate]))

I mean what is the Sales attribute that you are using here.

Please provide more details if I failed to understand your requirement