3 Replies Latest reply: Feb 21, 2017 8:06 AM by Rahul Pawar

# Calculating Measure based on conditions

Hi Guys,

Please forgive me if it is a little unclear as it is quite a complex problem.

I have piece of set analysis to configure where I achieve the following:

SUM(Tips)*Ratio/SUM(HoursWorked)

I have the SUM(Tips)*Ratio bit working I use an inline load and defined the values, they can then be used as a dropdown filter on the app.

however the hours worked is broken up into three types

Full time employee

Part Time employee

Volunteer

Which is a filter on the front page. How do I get it so that I can do something a long the lines of updating the figure depending on what they pick?

For background full time hours, part time hours, volunteer hours are columns.

I cannot provide an example data set.

also couldnt find the right place to put this any help is appreciated.

Thanks

Gav

• ###### Re: Calculating Measure based on conditions

It doesn't sound like it will be difficult to resolve but only if you define what it is you want it to do.

I know you can't post a data set but you could provide an example of a scenario you have currently and what it's producing which is the issue vs what it should be doing in your test cases.

Are you getting an app error for example? If yes what is it.

• ###### Re: Calculating Measure based on conditions

Sorry I was unclear mate

I want the three hours figures to accumulate based on what is picked on the filter

however the hours worked is broken up into three types

Full time employee

Part Time employee

Volunteer

Which is a filter on the front page. How do I get it so that I can do something a long the lines of updating the figure depending on what they pick?

So if the filter has Full time employee, Part Time employee, Volunteer and there are three columns for their hours worked

How do I get them to stack the sums based on what it is picked? They have the option to pick multiple choices on the filter too.

• ###### Re: Calculating Measure based on conditions

Hello Gavin,

Extremely sorry; but requirement given is ambiguous.

As per my understanding, SUM(HoursWorked) expression will change it's value based on current filter selection.

Please share application with sample data. This will help us to better understand the situation and provide you expected inputs.

Regards!

Rahul