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

    GetSelectedCount and alternative state

      Hi!

       

      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!

       

      Regards,

      Heidi