Expression Calculation Help

[pnn44794]

Hello:

I'm trying to calculate CPU and Memory amounts, and then sum the totals at the bottom of a straight table.

Neither expression returns any value.  It seems this should be pretty straight forward, but I'm obviously missing something.

As always, any and all help is appreciated.  Thanks in advance.

[swuehl · Accepted solution]

Please post the full context (dimensions and expressions used in your table chart).

It seems like you are just missing an aggregation function in your expressions:

Use Aggregation Functions!

Something like

=Sum(

If(Foundation_2 = 'VSI MEM' and (Foundation_3 = 'VSI Bronze MEM' or Foundation_3= 'VSI Silver MEM'), effective_item_qty * cpu_cores)

)

[pnn44794]

Hello Stefan:

Thank you for your reply. I will get the info together and post it, but most likely tomorrow (wife is on me to log off ☺ ). I did try your sum expression and when used, I lose the top 20 listing and everything is returned, though it does appear to calculate the MEM and when changed appropriately, the CPU quantities.

[pnn44794]

Stefan:

My apologies.  I apparently started two threads with the same topic and did not mean to.  My fault.  I've solved my problem with Sunny's help.  Here's the response I sent to Sunny in the other thread and again, my apologies.  Not sure how I did that but I did.

    Hello Sunny (and Anyone Else Following this discussion):

So, I've solved the problem, but it took you (Sunny) to point it out.  In this case, I cannot have an item with three rows where the item_sku is the same.  It just won't work.  So, I eliminated the duplicate item_sku numbers, tweaked my calculated dimensions and expressions and viola!  I'm now getting what I was after which was a top 20 listing by quantity to include the associated CPU and Memory quantities.

Many thanks to Sunny for pointing out the conflicts I had between the calculated dimensions and expressions.

Sunny, I will mark your last response in that regard as the correct response,  As always my friend, thank you for your assistance.  It's always appreciated.  Happy Holidays!