Skip to content

Replies

0
Tammy
Tammy answered on May 10, 2010 8:42 PM

ok, I figured out the syntax some but my formula still isn't working.  Any ideas what is wrong?

This is my formula for the unbound column.  It still includes all of the category_ids in the unbound column.  I want it to not include the ones below (10.2, 10.3, 10.5, 10.6, 10.8, 10.9)….

if(and( [Category_id] <> "10.2" , [Category_id] <> "10.3" , [Category_id] <> "10.5", [Category_id] <> "10.6", [Category_id] <> "10.8", [Category_id] <> "10.9"  ), [Annual_Spent_After], 0 )

0
Tammy
Tammy answered on May 10, 2010 5:24 PM

Can you give me some sample code?  I don't understand the formula of the grid and don't know how I can say:

Sum(if(u_id in (10.2, 10.3, 10.5, 10.6, 10.8, 10.9), 0, annual_spent))

Thanks….

 

0
Tammy
Tammy answered on May 6, 2010 9:04 PM

What if I only want to sum certain rows in the column? 

Say I have 10 rows in the column but only want to sum 5 of them and display it in a textbox?   They do have a u_id, so how do I say "only sum these u_ids together"?