Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with VAR statement (result)

jj I am trying to add another option to my "return" statement below.   I have the answer for if the first VAR statement is true...now I need show what the result be if the second VAR statement is t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    CNENFRNL  Anonymous  Ashish_Mathur   Samarth_18   Thanks all for your help.  In the end, I was able to get it to work with this which was a lot simpler than I thought.   

     

    Net Revenue (not including current month) =
    IF(SELECTEDVALUE('Net Revenue Table'[Reconciled?]) = "Yes",[Sum of Net Revenue],IF(SELECTEDVALUE('Net Revenue Table'[Reconciled?]) = "No","Pending",""))
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

Whether the advice given by CNENFRNLAnonymous  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry