dtietz Posted September 18, 2012 Report Share Posted September 18, 2012 Can I subtract a total from the a aggratte total of a field from a static total in a header or footer?? Quote Link to comment Share on other sites More sharing options...
HongTaiLang Posted September 18, 2012 Report Share Posted September 18, 2012 If the minuend number is a static value, you can manipulate the aggregate function results using mathematical operators (+,-,*, /). Example: SUM*0.6-100 But if the value is from footer or header, it is hard to insert into Caspio formula. You might need the code to achieve the whole aggregate function. Quote Link to comment Share on other sites More sharing options...
dtietz Posted September 19, 2012 Author Report Share Posted September 19, 2012 If the minuend number is a static value, you can manipulate the aggregate function results using mathematical operators (+,-,*, /). Example: SUM*0.6-100 But if the value is from footer or header, it is hard to insert into Caspio formula. You might need the code to achieve the whole aggregate function. do you have the code? Quote Link to comment Share on other sites More sharing options...
HongTaiLang Posted September 24, 2012 Report Share Posted September 24, 2012 Here is an example about calculating the sum of a column values in the result page : viewtopic.php?f=14&t=12180 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.