8 Replies Latest reply: Aug 13, 2015 4:15 AM by Sunny Talwar RSS

    GetSelectedCount and alternative state



      Can I use "GetSelectedCount" with alternative state?


      I am trying to create a conditional for my expression: sum({[Simulation State]}if([Project type] ='Back up project', Hours)) so that it would do the calculation only if there is at least one value selected in a field "Back up projects".


      When I try if(GetSelectedCount( {[Simulation State]} [Back up projects])<>0, ....) it shows error line for the Alt State first curly bracket.. Is it a syntax problem? If I add only() between getselectedcount and alt state it says expression OK but it doesn't make it work as I want.


      Thank you community already advanced!