Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

AR Aging Amount after adding RATE not working

Hi All   I have below expression working fine :- AR_AMT_ = if(sum(AR[AR_AMT]) =0 , blank(),sum(AR[AR_AMT]))   When i add above expression with RATE , it does not work :- AR_AMT_SGD = if(divide(...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Based on your description, you can create a measure as follows.

    _rate = SUMX(FILTER('RATE',[SOURCE]=SELECTEDVALUE('AR'[SOURCE])),[RATE])
    Result:
     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Thanks for your reply.

    In table “AR”, there are only two values(TS and TI) in "Source" field. So TA and TP display NULL.

     

    Best Regards,

    Yuna

aj1973's avatar
aj1973
Community Champion
5 years ago

Hi Anonymous 

Try this:

 

AR_AMT_SGD =

Var SalesByRate = divide([SALES_] , [RATE_] , 0)

Return

IF(SalesByRAte = 0 , blank() , SalesByRate)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi AJ

    I just try , it return the same wrong result :-

     

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      Paul,

      Sorry but you are not telling us what do you want to achieve!! more details would be more helpfull and sharing a PIBX would be even better.