Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum based on selected field

Hi,

I'm trying to calculate a sum based on a selected value from a field.

This is my formula. What is wrong with it?

=sum({<Application = {$(vApplication)}[[Scheduled Loads])

Basically, based on what selected value is in the Application List Box, I want to calculate the Scheduled Loads.

Thanks,

Adrian

14 Replies
maleksafa
Specialist
Specialist

is it something like that?

Not applicable
Author

Close, but not quite what I want. The line should be horizontal. Basically, what you did with the numbers is perfect, however, it doesn't look how I need it. What I need is my "design" with your "implementation". How can that be done?

maleksafa
Specialist
Specialist

but if you make the line horizontal then you mean that all the values across this line are equal which is not the case in your situation as the line value represent the scheduled load for each application. so for each application you will get a value which means that the line will not be horizontal, unless you want a static value across all dimensions like the average of the schedule load for all the applications.

Not applicable
Author

Exactly, I want the line to be horizontal, but I want different values on it, like a threshold for each application, that's why my graph adds the numbers "hardcoded" from the Presentation tab. This approach is good as well, but how can I make the numbers modify depending on my selection.

maleksafa
Specialist
Specialist

i don't think the option of horizontal line will work, now for the approach that i gave you, the numbers are changing if you select different applications, however with the date it is not working as your schema is not linked, you need to redesign your schema so that the tables are linked between Date field and [Week Ending] date