Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
6 years ago

balance with condition

Balance = SUM(vendorDTLPAY2_view[Amount (LCY)]) - SUM(vendorDTLPO2_view[Amount])​ Trying to add a condition to the measure above.  Need this field "vendorDTLPAY2_VIEW[AMOUNT (LCY)]" to pick only v...
sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
6 years ago

Hi AZ38,

 

Thanks for responding!! 

 

I seeing this message "TO USE SPECIAL CHARACTERS IN A MEASURE NAME, ENCLOSE THE ENTIRE NAME IN BRACKETS ([]) AND ADD A ] TO ANY CLOSING BRACKETS IN THE NAME" , I am trying to copy and paste what you have but it just giving me this message....am I missing something?

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Instead of copy paste try to write measure by yourself so that you will not miss any syntax or parenthesis.

Thanks
Pravin
  • sraj's avatar
    sraj
    Icon for Responsive Resident rankResponsive Resident
    6 years ago

     

    Yes, that's what i did and its working now...but the calcualtion is wrong.  This is what i am getting:

     

    Amount (LCY) = ($276405.42)

    Amount = $271555.14

    Balance = -547961

     
    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      so, sraj 

      what do you expect as desired output if you want to take into calculation only values "vendorDTLPAY2_VIEW[AMOUNT (LCY)]" tthat are less than 0.00."

       

      please give a data example and desired result

       

      do not hesitate to give a kudo to useful posts and mark solutions as solution

      • sraj's avatar
        sraj
        Icon for Responsive Resident rankResponsive Resident
        6 years ago

        The balance needs to be 4,850.28