LordsmanBurgos
Qrew Trainee
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: Summerize Sub-Summerized values from Child Records based on groups
I'm assuming these fields are numeric, in which case you could create a new field for every triplet and then Sum() the values: Field ChildSum_n+1: Sum([Child 1], [Child 2], [Child 3]) Then you can just summarize the ChildSum_n+1 results in a new field: Average([ChildSum_0], [ChildSum_1], [ChildSum_2], ...) Makes sense? ------------------------------ Lordsman Burgos ------------------------------Re: "Median" field using the new Query Formula Fields
Hello! You mean like the median of a field across multiple records, or the median of other fields in a single record, condensed and measured in another field in that same record? ------------------------------ Lordsman Burgos ------------------------------Re: Formula help combining quarters/summing
Hej Kelly! Are you trying to show this total in a single field, or multiple fields? If it's a single one, do you plan on using other control to filter it, or would this be for a report? ------------------------------ Lordsman Burgos ------------------------------Re: Save Table Aliases and use in formulas?
Just tried it from my side and it seems like it works. I'm trying this formula: SumValues(GetRecords("{1211.TV.'"&[Adviser_2]&"'}AND{2723.LTE.1}AND{2716.EX.1}",[AliasTest2]), 2716) Where the AliasTest2 field, is a Formula - Text set to [_DBID_DEVTEST] Let me know if you keep encountering issues, but from here, seems like your method should work OK! ------------------------------ Lordsman Burgos ------------------------------Re: Save Table Aliases and use in formulas?
Hej Gerry! Question, why are you planning to use the table alias instead of the ID? Something like: GetRecords("{3.GT.0}", "bck7gp3q2") Back to the question, you might try saving the text string as '_DBID_UTILITY_MATRIX' and then call the field. However I've never seen the table alias used in the GetRecords function. Will give it a shot from my side and let you know if it works :) ------------------------------ Lordsman Burgos ------------------------------Re: How can I make a text field show up only after choosing a certain option?
Edit: Wrong Screeshot, lol You can use a dynamic rule to achieve that. Just right click on any of the fields and select "Edit the properties of this from element...". Head over to the Dynamic Form Rules and set the field you wish to show with the Selected Value on your Multi Text. I did try it and it seems to work fine: Let me know if this helps. Cheers, ------------------------------ Lordsman Burgos ------------------------------ -------------------------------------------Pipeline Validation Error
Hej everyone! I'm trying to set up a pipeline that captures a value at 5pm.The one with the value is set to a Numeric Fomula: ToNumber(SumValues(GetRecords("{1211.TV.'"&[Adviser_7]&"'}AND{2723.LTE.1}AND{2716.EX.1}","_MyApp_ID_"), 2731)) The other field is an everyday blank Numeric field. I can write numbers between each other, but as soon as I try to write the value from the formula above to the latter, I get this error: Validation error: Incorrect template "{{a.total_adviser7}}". ValueError: invalid literal for int() with base 10: 'total_adviser7' I've tried these expressions: {{a.total_adviser7 | int }} {{a.total_adviser7 | float }} {% set stringNumber = a.total_adviser7 %} {% set integerNumber = stringNumber | int %} {{ integerNumber }} But alas, none of them worked. Any kind of guidance with this, would be immensely aprecciated. Cheers, ------------------------------ Lordsman Burgos ------------------------------
