Show Budject count as on

[Anonymous]

Hi All,

I have a requirement to show the below scenario in Text Object. Could you please help me.

Scenario:

In the Text Object, I want to show Budject count as on.

The requirement is if you select Quarter or Month it will  display corresponding Quarter and Month.

if you don't make any selection it will display as on .

I used this code:

=if(Quarter='Q4',Round(sum(Number)),
if(GetSelectedCount(Quarter) > 0,Round(sum(Number)/3),
if(GetSelectedCount(month) > 0,sum(Number),
Sum({<m ={'03-01-2016'}>}Number))))

it is working. But I need simple code with dynamically changing by Quarter and  Month. Pls find attached qvw.

Thanks,

Krishna

[sunny_talwar]

Dynamic based on what? selection in m?

[sunny_talwar · Accepted solution]

May be this?

=if(Quarter='Q4',Round(sum(Number)),

if(GetSelectedCount(Quarter) > 0,Round(sum(Number)/3),

if(GetSelectedCount(month) > 0,sum(Number),

  Sum({<m ={"$(=Date(Max(m), 'MM-DD-YYYY'))"}>}Number))))

[Anonymous]

Hi Sunny,

The requirement is if you select Quarter or Month it will  display corresponding Quarter and Month.

if you don't make any selection it will display as on .

[Anonymous]

Hi Sunny,,

=if(Quarter='Q4',Round(sum(Number)),

if(GetSelectedCount(Quarter) > 0,Round(sum(Number)/3),

if(GetSelectedCount(month) > 0,sum(Number),

  Sum({<m ={"$(=Date(Max(m), 'MM-DD-YYYY'))"}>}Number))))

Your code is working fine. how can i change Quarter Dynamically(Q4)

Thanks,

Krishna.

[sunny_talwar]

Krishna,

I am having difficultly understanding your if condition. What exactly do you want to see when Quarter is selected and when Month is selected? and What happens when both are selected?