Forum Discussion

jayasurya_prud's avatar
jayasurya_prud
Icon for Advocate IV rankAdvocate IV
3 years ago
Solved

Difference of Measure - Alternate Solution

Hi, I am working on a dashboard, where I am using cards visuals. Like below       In the card, C = A-B.  Now, I am facing the scenerio in which based on the filters, sometimes the value ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi jayasurya_prud 

    >>But since I am using if condition already in B to replace blabk() with 0, I am not sure hoe to get this. 

    please try this, 

    measure1= if(isblank([measure in card B]),0,[measure in card B])

    and put measure1 into Card B

    measure2= if(isblank([measure in card B]), "NA", [measure in card B])

    and put measure2 into Card C

     

     

     

    Best Regards,

    Community Support Team _Tang

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

jayasurya_prud , Not very clear

 

but you need like

 

c = if([b]=0 || isblank([b]) , blank(), [A] -[b])