ContributionsMost RecentMost LikesSolutionsRe: unable to create a field using report formula and chart report Goal label not visiblegood day, i would like to create a report like in the below screenshot. To create as same as below in QB i have used summary report then i tried to create a temporary field using report formula and it was unsuccessful attempt and in QB it is possible to have a constant value in a field for a particular report ? ------------------------------ Pooja Manickam ------------------------------ unable to create a field using report formula and chart report Goal label not visiblehi team, i would like to create a field in a summary report using report formula . i have a "teams " multiple choice field - internal ,external whose target is 84,28 respectively each month combined target is 112 these all 3 values has to be constant value in the summary how this can be achieved ? and one more issue which i have recently noticed is Goal label is not visible in the chart reports please find the screenshot for your reference ------------------------------ Pooja Manickam ------------------------------ Re: Formulathanks mark and Don this above formula worked once again many thanks for your support ------------------------------ Pooja Manickam ------------------------------ Formulahi, i'm trying to create a formula which will calculate a task completion factor depending other four factor like A - Occurence b- Time (duration required to complete the task), C- cost D-Quality these are multiple choice field and i have create sub field for calculation and Field A has (Very Low,Low,Medium,High,Very High ) and its sub field calculation If([Probability Of Occurrence]="Very Low (1-9%)","1",If([Probability Of Occurrence]="Low (10-29%)","2",If([Probability Of Occurrence]="Medium (30-50%)","3",If([Probability Of Occurrence]="High (51-70%)","4",If([Probability Of Occurrence]="Very High (71-99%)","5"))))) If([Time Impact]="Nil (0)","0",If([Time Impact]="Very Low (<1 mth)","1",If([Time Impact]="Low (1-2 mths)","2",If([Time Impact]="Medium (2-4 mths)","3",If([Time Impact]="High (4-6 mths)","4",If([Time Impact]="Very High (>6 mths)","5")))))) now i would like to perform some operation the A*(A+B) like 2*(1+3) =8 then we can categorize the task "easy,tough,moderate") but im unable to perform above operation please assist ------------------------------ Pooja Manickam ------------------------------ Re: webhook DoubtAs requested kindly refer the below code : <qdbapi> <usertoken>%user.token.b36eiy_knt6_d3vx.Demo Token%</usertoken> <field fid="11">[Project - Name]</field> <field fid="6">[Name]</field> <field fid="12">[Old.Status]->[New.Status]</field> <field fid="2">[Date Modified]</field> <field fid="5">[Last Modified By]</field> </qdbapi> ------------------------------ pooja pooja ------------------------------ webhook Doubti tried to create webhooks as shown in the demo course but could not get the expected output and found no error in the error history and also data were not reflected in the audit table can anyone explain the reason behind such scenario kindly find the below screenshots for your better understanding screenshot 1 :webhook is active screenshot 2 :Webhook Settings Screenshot 3 : in the tasks table i have created the new task but nothing was reflected in the audit log table (refer screenshot 4) Screenshot 4 : Screenshot 5 :Error History Re: I need to filter a report based on an empty Date field. Can I do this?[date field ]not is equal to date (blank) that's what i have implemented in the system but i wanted to try this report formula how it works and may i know the common reason why it is not working ??Re: I need to filter a report based on an empty Date field. Can I do this?i would like to filter a date field which are not empty .i tried the below formula If(not IsNull([Date Field]),[Date Field ]) - not working Re: Auto generated numberslet me give a detailed explanation on what i'm trying to do -the app is already in use but i have created a new table for sales project in which i'm trying to create a field called "Enquiry number- auto generate " and this field will be filled by respective project coordinators hence will come to know how many enquiries received and acknowledged by the coordinator . eg : A user creates a record - then expect output - EA19-001 (001 should the count project) B user creates a record -then expected output -EB19-001 Re: Auto generated numbersI'm trying to create an auto-generate sequential number....without using the Record ID #. i'm trying to count the Number of Enquiries received .we tested few formulas from various post now the record is11 ,this can be increased also - testing purpose but when end user adds a record the number should start from 1. the expected output : E19-0001 E-Enquiry 19-year 001-sequential number