Jump to content

Roosta

Caspio Ninja
  • Posts

    30
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Roosta

  1. @Meekeee Thanks for the information figured this out late last night by putting a couple of NULLIF & ISNULL statements into my claculations and just returns 0 now if people try to pick a futur date in the "Date From" field. Cheers, Roosta
  2. Hello all, I have an issue where if someone enters From/To dates incorrectly you get the following message due to the calculated fields I have used to create my own dashboards. I know why I am getting the message and want to replace it with something along the lines of "No records found for your selection please review and resubmit" but I cannot find this error messgae in the localisations and looks like its class is cbFormError which I have also lokked for in the styles gallery hoping to change there. However, I can find it but no way to change the message displayed. This is the displayed message: Displayed correctly: Any assistance would be greatly appreciated cheers, Roosta
  3. @astroboy Thanks for the suggestion but we have gone a different path using Caspios API to extract the data from the relevant tables and produce our own PDF reports outside of the Caspio system given its limitations. Kind regards, Roosta
  4. Hello all, I am using several datapages embedded using iFrames into a single datapage to produce an output for a customised PDF with has worked well when using a single parameter however I need to be able to use multiple parameters in a field, to explain. Say I have a column that contains engineers unique ID's in a format ENGID-4, ENGID-413, ENGID- 512 etc I am using a datatpage to search records with a multi-select list box which I want to pass the searched parameters to this datapage when a button is clicked. I have a hiddin virtual field which converts the output of the search field which is ENGID-4||cb||ENGID-413||cb||ENGID- 512 etc to whatever output I need such as ENGID-4 OR ENGID-413 OR ENGID- 512. I then pass this value using "Pass field value as parameter:" using [@EngID] to the relevant datapage I then assumed I would be able to use the "Contains" option from the filter fields menu as in the screen shot to get my desired results however, the results have not been as expected. For example if I pass ENGID-4 OR ENGID-413 it displays every record begins with a 4 e.g. 4, 411, 413, 425, etc. I have tried various combinations such as replacing OR with a space or comma but with no success. For example if I pass ENGID-4 OR ENGID-413 it displays every record begins with a 4 e.g. 4, 411, 413, 425, etc. I have tried various combinations such as replacing OR with a space or comma but with no success. The example below was for ENGID-4 OR ENGID-413 and should only contain Carol Danvers and Henry McCoy. Any suggestions on how I might overcome this would be gratefully received as I am trying to create a "batch report" containing tables, pivot tabes, graphs in one PDF. Many thanks, Roosta
  5. Hi @Shiro No I have solved this but can't post a screenshot of the trigger solution due to attachement restrictions (2mb total for account) but thanks for asking much appreciated. Cheers, Roosta.
  6. Well I was going to post an image of the working solution but apprently I have now reached the 2mb limit of my account attachements and the only workaround according to Caspio support is to create another account... even if you delete attachments from old posts they remain in your profile and cannot be deleted . My apologies if anyone was looking for a similar solution! Cheers, Roosta Heres a transcript fro support for those who are interested; Hello I was just chatting with Jojo and the chat timed out while I was waiting for an answer? Me Hello, I'm Jojo, thank you for contacting Caspio. Jojo Hello Jojo My chat timed out waiting for a response from you on attachements in the forum Me Welcome back. Jojo Thank you Me I have coordinated this with our internal team. And I'm sorry to inform you that we don't have the ability to increase the limit due to security reasons. I hope you understand. Jojo Can't some of the existing attachements be deleted? Me The other option will be creating a dummy account to post a new article. Jojo Seems pretty poor that I can no longer post any attachments for help or to help others.... And no I don't understantd "security" being used as a reason to be honest... Me I think it also won't let you to delete it because it will also remove from the previous post attachment. Jojo I could understand a limit of size per/item or post but not such a small limit of 2mb per account? Me As per our internal team, we highly recommend that you attached images only so it won't consume much space. Jojo I have only attached images just a lot of them as its the only way to explain with a visual interface most of the time Such as triggered actions Never mind I will just post I can't compete the thread or solution due to system restrictions of 2mb Me I'm afraid that there is nothing we can do about this limit in your account. What I can do is inform our product team and request to remove or extend the limit but I cannot promise you that they will implement it. For workaround, please create another account to post a new topic or article. Jojo Just seems a bit counterintuative you want people to discuss issues and help each other for solutions with your system then restrict them from doing so effectively... Me I understand your frustration but that is how the system is being designed due to security reasons. Jojo Fine as said will post the information you have given me so others are aware thanks for your help Me Okay, thank you for understanding. Is there anything else I can assist you with? Jojo No thats fine thanks have a good weekend Me Thank you for contacting us. Please do not hesitate to contact us again if there is anything further we can assist you with. You can also reach us at (650) 691-0900. Have a great day!
  7. Hi all, Nope this didn't work I was mistaken...! "Never mind got it to work was overthinking it solution is below;" Cheers, Roosta
  8. Hello all, I have been looking at the loop function in triggered actions and would like to use it for sending an email to all contacts for a specified customer, I have a submission form with a field where a customer can be selected and an option to email individual contacts (have that working fine) and another dropdown that can be selected to "Email all". I have tried to create a loop with limited success by that I mean it sends the email to the selected contacts ok but sends it multiple times to the same contacts for however many records there are in the contacts table example below; # So say there are a total of 100 contacts in the contacts table but only 2 contacts for the selected customer those 2 contacts get the same email 100 times (not ideal!) so I am guessing some kind of counter is going to be needed to count the number of contacts for the selected customer and ensure the contact/s are only sent the email once. However, I am not very familiar with this particular function and the Caspio online help doesn't have a great deal of information on the loop function that I can find. I am hoping someone has used it for something similar and will be willing to share how they achieved that, thanks for reading and any help will be greatly appreciated. Kind regards, Roosta
  9. Hi all, Not to worry figured it out using pass vaule on exit in search field then inserting that into the header and works for my purposes wothout having to utilise javascript. Cheers, Roosta
  10. Hi all, Well came up with a solution (off sorts!) for the Pivot table not deisplaying colors in the PDF genrator using the code below; <script> document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(4), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(4)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(6), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(6)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'limegreen'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(8), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(8)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'gold'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(10), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(10)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`table.cbResultSetTable tbody tr.cbResultSetOddRow td:nth-child(12), table.cbResultSetTable tbody tr.cbResultSetEvenRow td:nth-child(12)`).forEach(function(elem) { if(elem.innerHTML !== "0 %") elem.style.color = "white", elem.style.backgroundColor = 'darkred'; }) </script> Which gives this in the PDF output; Not terribly efficient I know put I think the problem was using; document.querySelectorAll(`[action*="[@cbAppKey]"] Which didn't specifically target the columns/rows that I needed to alter the Style of , hopefully this will be of some use to anyone trying to do something similar in a pivot table! Cheers, Roosta.
  11. Hi @AllMight and @LittleMsGinger I am trying to do something similar to this only with the values from the search fields in a pivot table to be displayed in the header, unfortunately in pivot tables you can't use HTML blocks so are restricted to using the Header/Footer for any code. I want to do this so when a PDF of the results table is printed using the Caspio download options it gives some context to the results for the user e.g. Name of person searched for, date range searched etc, etc as currently you can only use Authetication Fields, APP and System parameters in the PDF generator headers & Footers and can't display any of the search field criteria such as below; Datapage view; PDF Generator result; Have tried variations of getelementbyID such as; <html> <body> <p id="d1"></p> <script> function check() { var x = document.getElementById("Value6_1").value; document.getElementById("d1").innerHTML = x; } document.getElementById("searchID").onclick=check; </script> </body> </html> With "Value6_1" being the ID of the Date field "from" in a date search from/to criteria but without success and any help or suggestions that point me in the right direction would be appreciated! Kind regards, Roosta
  12. hi @Nuke354 Well I thought I's solved it, not pretty but thought I had,,,, <script> document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(5)`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green' }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(5)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(8)`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(8)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(11)`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(11)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(14)`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; }) document.querySelectorAll(`[action*="[@cbAppKey]"] td:nth-child(14)`).forEach(function(elem) { if(elem.innerHTML !== "100 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) </script> Which gave me this in a preview of the pivot table: Great I thought should print on the PDF now but when printed got this; I have absolutely no idea why it doesn't print in the PDF but shows in the preview (which when using JS to manipulate it via CSS it doesn't) it would appear that pivot tables just don't behave in the same way as tabular results tables! Unfortunately as you can't inset HTML blocks in pivot tables the methods used in tabular reports for checnging colors using a unique row ID and a varible can't be used, also in the header/footer you can't select data fields only authentication fields so if [@field:xxxxxx] etc isn't an option either hence the hack above! Oh well back to the drawing board any suggestions gratefully recieved would be much esier if Caspio had conditional formatting as a native option for the data fields... Cheers, Roosta
  13. Hi @Nuke354 I found a partial solution which I modified slightly for the columns being the same color on the pivot table in an old post using this in the header; <style> #target table:nth-of-type(1) td:nth-of-type(3) {color: white;} #target table:nth-of-type(1) td:nth-of-type(3) {background: green;} #target table:nth-of-type(1) td:nth-of-type(5) {color: white;} #target table:nth-of-type(1) td:nth-of-type(5) {background: limegreen;} #target table:nth-of-type(1) td:nth-of-type(7) {color: white;} #target table:nth-of-type(1) td:nth-of-type(7) {background: gold;} #target table:nth-of-type(1) td:nth-of-type(9) {color: white;} #target table:nth-of-type(1) td:nth-of-type(9) {background: red;} #target table:nth-of-type(1) td:nth-of-type(11) {color: white;} #target table:nth-of-type(1) td:nth-of-type(11) {background: darkred;} </style> <div id="target"> and a closing </div> in the footer which gives me; Still working on somethin to replace the CSS manipulation with a style change if anyone has any ideas? Cheers, Roosta
  14. Hi @Nuke354 Unfortunately this method does not appear to work in pivot tables only tabular reports unless I am doing something wrong, I have tied inserting into the footer as you can't put html blocks in pivot tables to deploy code in this manner; I did have some limited success using the following in the footer; <script> document.querySelectorAll(`[action*="[@cbAppKey]"] .cbResultSetCalculatedField`).forEach(function(elem) { if(elem.innerHTML == "100 %") elem.style.color = "white", elem.style.backgroundColor = 'green'; else if(elem.innerHTML== "50 %") elem.style.color = "white", elem.style.backgroundColor = 'red'; }) </script> Which gives; However it utileses innerHTML with spevified values and I cannot figure out how to apply to a single column where I could use just one color for a column or criteria for that column only such as 100 % else etc, etc. Thanks for responding, Roosta
  15. Hi @Nuke354 Thank you for the reply its much appreciated but I don't quite understand how I can use that code alone for calculated fields without setting the "isi" variable as per the code above; var isi = document.getElementById('visi[@field:ID]').parentNode.parentNode; I am very unfamiliar with this type of syntax/use so any help would be appreciated, I have tried using just the line of code you suggested in the above and omitting the getElementById but it doesn't work. I ran into a similar problem with a different pivot table where I wanted to change the colors of certain cells with a % in them and ended up doing it via the css when the page is deployed using on my website by inseting the following code in the footer; <script> $("table.cbResultSetTable tbody tr.cbResultSetOddRow, table.cbResultSetTable tbody tr.cbResultSetEvenRow").each( function (x) { $(this).children().each( function(){ if ($(this).text().indexOf("%") != -1){ if ($(this).text() == "100 %"){ $(this).css("color", "white").css("background","green") } else { $(this).css("color", "white").css("background","red") } } } ) } ) </script> Which gives this result; However the only problem is using this method is the actual background color is not altered so when using the Capios PDF function the CSS style changes are not printed would a similar soultion be possible using the methods above as well? The printed output to PDF comes out like this; Many thanks, Roosta
  16. Hi @Nuke354 Is it possible to do this with calulcated columns/fields in pivot tables doesn't necessarily have to have a value criteria just want certain columns to have a set background color and they are calculated fields? For example: Pass = Dark green Pass (advisory) = Light green Improvement = Yellow Fail (supervision) = Light red Fail (immediate) = Dark red Kind regards, Roosta
  17. Hi @NiceDuck Where did you get those figures from as it doesn't state this in the pricing schedule for basic plans https://www.caspio.com/pricing/basic-plans/ in fact Triggered actions doesn't state a monthly or daily limit at all only Notification Emails, SMS, Import Update, Scheduled Tasks and REST API have a stated monthly limit?
  18. Hi @hercules97 To be honest a lot of it is going to depend on your method of deployment, what your trying to accomplish, the end users skill levels (are they familiar with using databases or is this a general public facing application?) and your expectations given that Caspio is ultimately an online relational database for collecting, processing and displaying data/information. We are deploying our system via a self-built website which gives a lot more flexibility with layout and additional code JS/HTML/CSS than say using a website builder such as Weebly or Wordpress. So some questions; What are you trying to build How is it going to be deployed How familiar are you with relational databases and structure Do you have any coding skills such as JS/HTML/CSS Is the system you are building be integrated with other systems such as mobile applications using REST There are many more questions I could ask but these seem the most relevant to begin with, I am by no means a professional coder/programmer but have had extensive experience with MS Access and Visual Basic in the past and these skills helped. You need to set objectives e.g. what do I want this datapage to do and how am I going to deploy it, what user interactions will be required etc, then if you need help trawl the forums and see if anyone else has had similar problems and there are plenty of people here who are willing to help (I have only been using the forum a short time but found it invaluable as much for seeing what can't be done and looking at solving it in a different way!) You could always use Caspios "Expert Sessions" add-on; However its not cheap and I would advise if you go down that route you have a good idea of what it is your trying to accomplish before booking a session/s Failing that you can try Caspios "Professional Services" we have used them for a project that I didn't have time to learn how to implement myself, again not a cheap option but they are a good team of people and will get you where you need to be if its a business critical function that you need to implement reasonably quickly. Sorry for not having a definitive answer but you asked a pretty broad question with little to no information of what your trying to achieve, how you have tried to implement it and how far you need to go. Kind regards, Roosta.
  19. Hi @roattw If this is a submission form I assume you mean something like this; Where you can have headings over each section? If so you can split the form up into sections with columns to suit and have HTML block in-between their own sections set at 1 column to span the page like this; This is one column proceeded by the HTML block with the next section containing the submission form fields; You will have to experiment (a lot!) to get decent results and spacing for your whole form as if you start mixing section columns other then 1 and X (in my case X = 5) it will space them to overcome this I either used columns of 1 or 5 and if required less then 5 used 1 and had the elements continue on the same line. Your other option would be to build a full HTML table within the HTML block something similar to this; <style> .wrapper { background-color: lightgray; padding: 5px; } td { padding: 10px; } </style> <table border="0" cellpadding="1" cellspacing="1" style="width:100%;"> <tbody> <tr> <td><strong>Some Data 1</strong></td> <td><strong>Some Data 2</strong></td> <td><strong>Some Data 3</strong></td> </tr> <tr> <td class="wrapper">[@field:Some_Data_1]</td> <td class="wrapper">[@field:Some_Data_2]</td> <td class="wrapper">[@field:Some_Data_3]</td> </tr> <tr> <td><strong>Some Data 4</strong></td> <td><strong>Some Data 5</strong></td> <td><strong>Some Data 6</strong></td> </tr> <tr> <td class="wrapper">[@field:Some_Data_4]</td> <td class="wrapper">[@field:Some_Data_5]</td> <td class="wrapper">[@field:Some_Data_6]</td> </tr> </tbody> </table> Which would result in something like; Again you would have to experiment with layout to match the rest of your form/fields but may be a possible solution but without seeing exactly what you want as an end result its a bit hard to offer any further advise. Good luck, Roosta
  20. Hi @Vitalikssssss We have come up with a partial solution which I have posted here if you want to have a look it might be along the lines of what you were thinking already or maybe you could improve on it which would be appreciated Kind regards, Roosta
  21. Have a solution sort of... This works for the way I have the datapage deployed but probably won't work with direct URL's or deployment via Weebly or similar as it utilises the CSS code of the website page its deployed on and therefore also doesn't work if you try to download the data as a PDF but works sufficiently for my current needs; <script> $("table.cbResultSetTable tbody tr.cbResultSetOddRow, table.cbResultSetTable tbody tr.cbResultSetEvenRow").each( function (x) { $(this).children().each( function(){ if ($(this).text().indexOf("%") != -1){ if ($(this).text() == "100 %"){ $(this).css("color", "white").css("background","green") } else { $(this).css("color", "white").css("background","red") } } } ) } ) </script> Probably not the most elegant solution in the world but gives the following results in the frontend webpage when deployed in the footer of the pivot report; It would obviously be far easier if Caspio had a conditional formatting function in the "formatting" section for Values but in the absence of that this may be useful to others if all you need is to format the display of certain columns. Thanks for looking, Roosta
  22. Hello all, I have been putting together a simple pivot table view to display outcomes and percentages of an audit process that we perform which looks something like below; I would like to conditionally format the "% Correct" columns so that they are Green if = 100% or Red if < 100% I have found this a bit difficult as there do not appear to be any Element ID's associated with the cells, I got the result below by using Class Name and column No; Using this code deployed in the footer; <script> function f_color(){ if('[@calcfield:11]' == '100 %') { document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.backgroundColor="green"; document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.color="white"; }else{document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.backgroundColor="red"; document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.color="white"; } } f_color(); </script> However it doesn't switch to green when the field is = 100% (see below I assume this is because the calculated field I am referencing is either the incorrect syntax or can't be used in this way ) and as you can see doesn't apply to all cells in the respective column; Any suggestions or guidance would be gratefully received as I am probably going in completely the wrong direction and I have searched the forums and can find a number of suggestions/solutions for Tabular reports but nothing for Pivot Table reports. Kind regards, Roosta
  23. Solved it! (well sort of...) To get round the issues I created a number of formula fields in my results table similar to this creating columns of 0's and 1's depending on the results which can then be summed; CASE WHEN [@field:AS_Audit_Sat] = 'Satisfactory' THEN 1 ELSE 0 END Then in the pivot tables calculated field that I need to get a percentage I used; ISNULL(SUM([@field:DEA_Main_Body_AudOut_Sat]),1)/(SUM([@field:DEA_Main_Body_AudLive_Val])) Setting the format to percentage with the result being this; This has also saved me from having to use Select Counts in the other calculated fields as all I need is something like (yes I know I could have set the calculated field to summarise by "Sum" but it puts "Sum of" in front of the column label text which I didn't want); SUM([@field:DEA_Main_Body_AudOut_Sat]) All I need to do is get the conditional formatting of the % columns which is a bit difficult as there do not appear to be any Element ID's associated with the cells, I got the above by using Class Name and column No. using the below; <script> function f_color(){ if('[@calcfield:11]' == '100 %') { document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.backgroundColor="green"; document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.color="white"; }else{document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.backgroundColor="red"; document.getElementsByClassName('cbResultSetData cbResultSetTableCellNumberDate cbResultSetCalculatedField') [3].style.color="white"; } } f_color(); </script> However it isn't working for the whole column or changing color based on the value as can be seen below; So as always any suggestions would be gratefully received! Many thanks, Roosta
  24. Hello all, Well I am getting nowhere with this, I just don't get the syntax used in Pivot Table Formula FIelds I can do this (Count + Count); IsNull((SELECT COUNT([@field:DEA_Main_Body_RecordID]) from _v_DEA_Eng_Pivot_AudSatPer Where CUS_Contrator_Engs_Full_Name = target.[@field:CUS_Contrator_Engs_Full_Name]),1) +(SELECT COUNT([@field:DEA_Main_Body_RecordID]) from _v_DEA_Eng_Pivot Where CUS_Contrator_Engs_Full_Name = target.[@field:CUS_Contrator_Engs_Full_Name]) Which avoids a Zero in the first Count (The second count will always have a result of >0) But I can't do this (Count / Count): IsNull((SELECT COUNT([@field:DEA_Main_Body_RecordID]) from _v_DEA_Eng_Pivot_AudSatPer Where CUS_Contrator_Engs_Full_Name = target.[@field:CUS_Contrator_Engs_Full_Name]),1) /(SELECT COUNT([@field:DEA_Main_Body_RecordID]) from _v_DEA_Eng_Pivot Where CUS_Contrator_Engs_Full_Name = target.[@field:CUS_Contrator_Engs_Full_Name]) As it returns an "Invalid Formula" when verifying. I can't get the [@calcfield:X] use to perform in any rational manner either for example SUM([@calcfield:9]+3) seems to result in the Calc Field value added together 3 times so if its value = 1 then its 1+1+1 =3 not 1+3=4 or if you try to use [@calcfield:X]+[@calcfield:X] within a calculated field such as below; It verifies as a correct formula but returns "Error in formula" when trying to preview. There is very little information in Caspios help files for Pivot Table Calculated Field Formulas and they don't seem to behave the same way as tabular reports and the syntax definitely isn't the same as standard SQL. Any help or guidance towards some documentation for correct syntax would be gratefully received, failing that I think my only option may be to create an HTML Table in a form datapage using HTML blocks and figuring out how to display the required data. Thanks all, Roosta
  25. Hi all, After a little experimentation I am pretty sure its not recognising the Calculated Fields within the formula as an experiment I tried [@calcfield:9]+10 which just gave me a column all with the value "10" but should have been various values such as 12, 11, 13, etc when I tried ([@calcfield:9])+10 it verified as a correct formula but then displayed "Error in formula" when previewing. Maybe the Pivot Table Wizard doesn't like referencing Calculated Fields within another Calculated Fields formula? Kind regards, Roosta
×
×
  • Create New...