Ascend Calculated Field with airSlate SignNow

Integrate calculated field

this conference will now be recorded okay no calculated scenes as I told you are always like on you can see like on a particular voltage eliwood field or on a like particular business object in that part of the fields calculate fields are created on that they are not like creating any new field but it's just like having existing work they feel you are making some calculations on it like there is no separate space or like separate field which is being created when you can you create a calculated custom fields or something which is altogether different like let's say take an example that in vogue this finale a us-based application tool right so there is nothing called let's say I'm just assuming that there is nothing called pan number let's say in the system so create a custom field called pan number will restore the pan number for all the Indian employees who are there in u.s. if they want to track a keep a track or keep a record of that so that is what custom field would be which is not being delivered by Bombay and but still you have to maintain some data related to that that is what is called custom food calculated fields are nothing they are not like creating a new field in the system they are like using the existing fields you are putting in some logics or some calculations and extracting the data in such way okay so the calculated fields can we can create a calculated field on a custom one a custom field - right exactly these can be worked on anything so what's the whatsoever is there in that energy will create calculated field on that I don't I have a question on the function for single instance and multiple instance okay could you show us like two examples of for single and multiple okay so did you see like a manager manager is a single instance field because for the particular supervisor organization there is only one manager right before an employee there is only one manager but let's say dependence we are a multi instance field reason being a person can have multiple dependents related right now these single instance of my teens like which particular object or a free so let's say in this case manager independent sex empowers everything the object has water that is the employee right now for employee what kind of data will be present whether it is a single instance my team system so the manager for Martha will always be one because for a supervisory or Ganesha there's only one manager right so for work the manager is a single instance but for vertical dependents can be a multi engine because they can be single dependent up they can do by D Phi dependence tied up to that particular worker its that winning sense yeah yeah right so this single instance in my teens dependent on the object which you are talking about your having for which you are looking into whether it is in around let's say the same question I'm watching right you gave me an offer for a organization I am organization what is it body man if you have any I don't know how I forgot that so bro is the reorganization has got only one manager so there's a single instance they it's the yeah if we take the dependence right the relationship in the the business object like you know the employee the worker employee and a different defendant business objects if so one is one to me exactly right that's not I mean one to minute what the one particular guy in the worker can have multiple dependents are the dairyman have any difference are the thing I want be one different no one too many is like zero too many that is some goes over at them fine to zero too many that is wait so because of that relationship we are saying a dependent is the multi instance right exactly okay because why if one day has got only one deponent still we say that it is a math it is it is a multi instance even though it is not it doesn't matter in that particular business of I mean in fact dependent object or not but the field which has been configured in the system is that it can have I depend at a time when the Salva what's wrong Thanks yeah so any any other question but we'll know we had learnt about the true/false gal field we had learnt about so today today the first thing which I talked about which is like a very key he calculated field in the system and the whole flow goes something like that now if you remember this is very important of you guys like the three kalki to jump on it and you now is very important for any of your custom the course orientation saleability into the system so if you if you recall like the report which we had built on the wire independent pyrite so what you're doing you only thing Augusto sorry sorry to interrupt but are you recording session I don't know it's not me who blog that I think it's about it yeah it's like okay and say okay well I just take that that it's required so what I'm saying like if we remember the custom report we had created on ban the first custom before we write what we are doing we were choosing the vertical business object and then we were putting in my curve the first name the last name of the employees right that is what we have something and then you would say anything that dependent business object and extracting like the first main mass is correct this was some what we were doing in the custom report right yeah now now suppose the question is like that create a custom report now there you have to fetch only the first child okay the first time that is suppose if the customer is the if the employee has three children you have to only extract the eldest child so the requirement is like extract Elvis to try from the dependent section and put that in custom report also do not include employees this is my requirement so what will I do can somebody put a guess not using calculator to it can somebody with me so if you read this you can see my screen right so we have to extract this extract the eldest side from the dependents section and put it in custom report also do not include employees who don't have the children yeah you are to do not into the okay my question is I'm not saying who don't have dependents they can have a spouse but I'm saying do not include who don't have the children right so there is any specific filtering criteria I'm referring a filter one because it is on the not on the video what how did you do this in filter how will you do that agree part in filter yeah just think man I'm thinking Gloria I think you do with some kind of aggregation or a sexists something like that bodies exist so I am sorry I missed what you said something called exists operator [Music] why it says benevelon yeah so any other other guess so the relationship would be child yes or no okay but will that work at the filter so yeah I mean if you if you say relationship child then it will filter note employers who have children are you sure Massimo if you are but but this one is agree employee record you know so if you you cannot choose those dependent object feeds in the filter pipe yes Rani can we take dependent as a primary business object well creating a little concept will be out right okay that's that's fine so I mean if you use lookup related value then we can bring that field on to the primary business object then right okay fine that's that's that the last step we will doing this so before that there are few steps so you finally reach you can say at the Mount Everest off without even climbing so you put that you use the helicopter and jump to that right okay no so I tell you like by I mean this can be any situation I'm just an example of dependent but now here you have to think in the way and if I would try to expandable so now think of it if you remember the concept of single instance and mighty in strength right so now here first of all you have to understand on the related business office that you talk in the house whether it is a single instance or a mighty instance one table right might instance means they can have different different relationships and that let's take an example of dependent only it can have multiple childs it can espouse it can a father mother or anything kind of that right now if I'm talking about specifically one child what am i saying I'm saying that out of all those instances I have to extract only one instance that's right right okay ready yeah so for that there is one calculated field which is called the extract single instance what this calc we will do is it will go to your day related business object that is not is dependent and based on the condition we will create in that it will extract that particular instance is that making sense what I'm talking what is the name of the calculator what is the type of the calculator field it's extract single instance extracts single instance okay what this can how this calfy works out this calculate works out this that first of all we have to tell for which particular object we are taking on the extract single instance Cal field so in our case we are working on the dependent business object right did he write now extract single instance there is one more requirement which is called the condition that is what particular condition you are putting is to extract the data now if you remember Sigma the condition if you had told that the relationship is equals to child right so first of all what what work they will do using this Cal field it will check okay that condition is that relationship this child so first of all it will extract all the child from your dependent income you know right so some input to child three child or geo toy whatever it is it will extract that then since another thing in extract single instance which is called the sorting so now as I told you that we have to extract the eldest time what will be the sorting for that particular instance how can you sort your data to get the Einstein ascending descending one is on the age each other age you can sort it so suppose you are sorting at all that will be on the descending order that means your first two instance will be the eldest child you know when you sorted your suppose also would come first right how you are eliminating this hopefully for extract single instance there's a field which is conditioned achar okay it will extract only those instances while passing this right right understood the condition it will do the sorting right let's say employee has three children then multiple instance because we are getting you are not literacy my question is parting all the instances out of those instances were extracting only one instance okay the end is chatting it yeah what extracting only one instance if that question would have been extract all the sides then it would have been like my instance expression so there's one would help free which I will cover after this I'll cover that that is the extract my instance that I'll cover later to explain your this question but for this particular scenario you getting why I did the extract single instance yeah is that making sense to everybody yes is very clear one right so now we will do the sorting and then on the sorting we with in which position you want to extract so now suppose if you are doing it on this end in a descending whatever you get the first position if you are doing into the ascending order will get the last Buddhist is that making sense yes in couple of days back when you are explaining about the repo hood you I remember you told me one on fact practically business object instance will always report it whether the related business object record is there or not let's not matter and I'm not reading any be put with the filter or anything just a plain report okay right so the primary object PB you OPP or occurred by instance will be there whether that people know has got any instance for RB o or not right that's what he told me exactly right suppose now coming coming to the current example that we what you're explaining okay so or creating and a calculated field which is called extract a single instance field right yeah not able to so let let income book but till the time is that is that making sense to everybody else like yeah okay that is a query of aa rule the query or Bala is when we put in a filter it will not applied on us a primary will this object so when we say extract single it chord it will apply or dependent table but the all the records of primary table will display in this report right exactly so after that we have to put other filter which will see no filter only those employees will have so can I ask the question or should I wait for some time no no okay this one suppose if you're creating a calculated field with the single instance kind of thing and I'm dealing with the one particular instance of a PPO who does not have any RB or a car so that the car will be retained or if you want be retain just because you are forcing the system to see at least one instance from RB oh no no so see I know we have not put in any filter in the report right so all the records will be there irrespective of whether they have dependents or not that's first thing right right now we have not used any of the filters right now suppose for the reports all which they don't have any dependent this particular single instance will leave it hello-hello turn a blankie you can you so are you getting you know you can you please repeat it yeah what I'm saying yeah you're good no okay what I'm saying is that first of all we have since the report is on primary business of the fall but it will extract all the work I did in this video whether they had dependents or not that's worse then right now we expect single instance for all the workers in the system whether they have dependent or not it doesn't matter because we have not applied any filter filter right now now if we are creating extract single instance it will work for those employees as well who have the dependents right so what will happen when we'll run this calculated feel for those employees you don't have the dependent it will send a blank data like this Cal field will be blank okay okay now we can use this calculated field because extract single instance is always created on primary business object okay so since this is very con worker you can put it in your filter that extra single instance is not black so if not all was only be clear a statement is always primary business object ODB say yes extract single instance field when you create so you remember that everything absolutely create we have to choose the business object at the first page itself right right whenever you extract single instance you will always choose the primary business object which is the word inside that you will choose what particular related business you you are applying for this calculator right so primary will always be working so now since your calculated field is on the worker you can use it in your written just to use a filter that is the reason you are choosing your primary business object there right exactly so that you can directly use it like that so it is not necessary that your business object should be your primary business object just because if what would be the effect okay assume that I don't have any filter condition okay what would be the effect if I associate the calculated field to a rbo instead of a PPO then it will not be you will not be able to put any filter on that right okay I don't have any requirement for Phil to assume that okay so if I associate calculated business fields with rbo instead of PPO assume it I don't need to have any filter then the report both both type of report will give you the same output right right and why the reason why you are attaching this calculated field with the BB you just because you can enable the filtering option there exactly okay so got it back right now this whole condition of extract single instance is here so any other is showing something on the screen is it visible oh yeah now it is usable so now is that making sense for this extract single instance whatever I have written to highlight it is that making sense for everything yes or you can we do it real time but if you don't mind I do that but before that I wanted to me to understand the flow so that when we build it will go now there is one thing which is spending inside this that we have to create the condition as right right so now if you have to create a condition you remember I know there is one calculated lipids can build that conditions what was that true or false whatever that is for any extract single instance you have to create a true false calculate well why you are for why you are building this with just two because to filter out all the PPOs who does not know no no no by me so if you remember what I did in extract single instance I totally put in the condition so that we can extract only those two instances which are five children we are filtering out the spouse data right right right so that means this condition is inside there single instances it has nothing to do with the filtering of report forget about that so for extract single instance you have to create a condition which fills that out of all the multiple instances treat I it has what kind of instance you have to extract from that particular object so let's say for dependent can have multiple relationships like where the fathers are the sister child anything like that if I have to extract oh so different data you have to put in the condition right then I want to extract out of this multi instance mean I want to extract only this particular records but right give me a second well then this condition to our house condition should be first created before you extract the signal instance guide in fact is that making sense why we are creating a condition yeah in addition but the condition has to be created first right before you come to the extra resistance exactly this true/false can be Shenfield will be built on which business object different exactly so now you understood the flow law that is creating extract single instance the extract single instance business object would be the primary business object and the true/false calculated field will be the different related is that making sense yeah yeah yeah you ask others also much I mean just I am answering okay please no I don't know anybody to answer we understand is that making sense so now what will you self condition is particular to possibly anybody else what is the name of the field it's called a mouse pipe or something like that relationship relations are effective that should be equal to type right and that returns true the relationship will be a field which we tell that if relationship is child only yeah yes right so we will create a calculated if that relationship is child and then we'll go to our instance and then it will extract the beta related to that particular child is that making sense everybody yep yeah this one right so now we'll go to the system yeah I don't know I have one actually confusion or till when we create a calculated fields it will bring that particular column to a primary business of the grade or okay right so you don't worry about those things whether it is a part of critter or not forget about everything if I just asked about these food lipid fields is that making sense hundred Wilson right forget about the calculating or any kind of different data out we'll come into the report but how to create these calc two calculated suites is that making sense this is right so now let's see how we'll create these two calculated fields in the system so that we can move forward so the first thing I have to do is the true/false calculated field I have to create so the task is like we it completely I'll put in the name what is T of true/false or the type of - I am creating sorry Maggie stupid question so this is the for naming I mean for me it's like I have developed for so many projects so my may be commenced and all this happens like about tracking so now I am building this fruit on the related business object sonar is the related to the subject is depending right then the type so here if I tell you that the field which I have to select this relationship so I'll just so I will choose if you see if you go to this particular officer these are the campus which is already being created forget about it you'll only work they were worried about the Vulgate anyway so what it is the relationship of the beneficiary to the employee for examples our daughter son kind of that right so I will choose a field as relationship now operator is something like we do within the like any anything in the mass site so whether it is endure so now we will talk about in Bombay if it is like in the selection list means now comparison value which will write that it will compare it I'll show you how then it will make the move here he is more now equal sign no no no this is how you have to do it so for equals there's one field which will be like I think equal so that will be great so equal to will always work on the number five right so this is a character field okay this is active right so you choose in the selection field and here you will see all the relationships in the system right Choi in domestic partner and ex-partner ex-spouse friend whatever it is silence a child in the time we are selecting as relationship this child how the comparison type you it is auto populated yeah that will be Auto populate I'll tell you what it is what is there in that so this is the first bigotry which I'll create that is this now here if you see that one is value from another field one is when you specified in this filter now value for another field is what suppose you have supposed take this example in this like suppose you have to use any other field right now you are just hard coding the value right that relationship is equal to the child but you can choose any other work that any will feel you know it is having some data tell me okay I hated this to first calculated field just to avoid a sequel statement they are complicating the screen man okay maybe much it but well you know what happens when you write the syntax then there is not many things you have to worry about like think of the BL syntaxes and everything it is just a heart just all the things are like I put it you just have to send it out there configuration right I understand understand that so now we will create another calculated field which is the extract single instance now you do the same you do the same thing no no this there's a direct shortcut right if you click create event button that you need to little common way but if you just change it I am become confused okay so once you have created that was California again oh now I'm creating an extract single instance and this put in money I'm creating in the worker business object and then I am extracting the child right now since I'm creating extracts in the single instance as I told you that my prime leaf is the software business object would be worker because I would I want to bring that dependent detect to the worker level itself right so here I will choose my updated view as extract single instance so now if you see there's so many things cover now so one is the source field now what will be my source field here your child this relationship right so speed would be eight gauge know that is more soil field names are sweet from where you are extracting the data so from where we are extracting the repo they pretend exactly to deprive hundred atoms of sphere to source suitemate and where you are applying this all conditions is that making sense yeah wait and feed it so real is there is a business object now no okay let's just add dependent if you see we have chosen this field and it is another related business of the foil defending okay so if you remember if you remember I just recall you if you remember when we were creating a custom report menu when you had changed the primary business object worker to the dependents the source food you had choose inverse dependence if you remember the source line use but your data source know so in every business object you had all those degrees uh turkey is uh okay okay okay okay anymore those peel those are all the fries and in and this field is representing to the related business object because we have the eating our extract single instance for the dependents business object right so the source field will be dependents and automatically the related business object will be populated now what will be the condition here you were to the true/false calculate which we had created is why this condition has come up here the reason being that profile sweet which we had created was on the dependent business object weight right so whenever whenever so there is one shortcut which I tell you now before I further continue with this whenever you are having a confusion that what will be your true/false feed a business object this choose the source field here and you will understand like on what particular business object you have to create the calculator fees I just change it don't relate it with the examples suppose I have two extractor I mean you can see suppose I have to extract any other related of them co-op so let's say organize it let's say organization I'm just saying an example suppose I have to extract the cost Center data suppose I have two extra so I'll see for one all the assigned organizations right no you're getting what I'm saying Yeah right it is a key right yeah so what I'm saying is like how to identify what will be the dependent what will be the true-false business object if you're not directly able to understand that what will be my business object for true/false what you can do is create your extract single instance field go to the source field so suppose in one case like we have to extract the cost centre for the employee so how we can extract the cost center of the employee it's more like that employee will be tied up to so many organizations right whether it is costs into the company region location Iraqi cost Center and II may be custom organizations whatever it is right so my source field will be all the assigned organizations to the worker right so if I choose it if you see then automatically the related business object field will populate right that is now the related business object is organizing so what will be a business object for true for Speed organization is that making sense yeah right so whatever whatever oh faults whatever true/false condition is there in that particular object will be displayed in conditional yeah very doesn't it exactly but right now we are talking about the dependent I'm just taking an example of the dependence of me so I'll put in my condition now inside this like you see all the fields these all things will be related to the fields which are under their related business objects right the true/false will also be in under the related business object now if I am doing the age like sorting as I told you will be done on the age so now this age will also be under the related business object of the worker right right so now how this force fields will work if somebody can explain me how this whole flow will work here yeah I can explain if you guys want to not burden go ahead well no I got somebody else to go that's why I said let me give me a minute please understand yeah so I like any one of you apart from politics Taylor say it will come on the related business object and check to visit children where whether the dependent object has a children if that is true it will go and get a h-field and when we say ascending it will give you a small number top and we conjugate it to occur object in panic annuals can you explain now experiment beginning so you you first of all you need to have a conditional requirement or to figure out whether that particular dependent is a child or anything else right because the logic is first we need to figure out the child you once have a child you need to figure out the eldest of eldest is child from that particular slot right so the first calculated field will filter out everybody else other than child rightness but still the first condition would not give you only one child in case if you have multiple children right is it you mean one more calculated field to filter out the rest of all and you want the first guy right so that's why you go for a single instance right in the single instance you will specify and which business object on which mr. subject under the filter condition and and you are going to filter based on what field which is age and assuming order that's all you really do it correct is that making sense sure but no I think it's fine I know it's fine here no you were Stephens gone yes leaders come okay yeah so now what I'm seeing is that in this whatever we have done so my sorting Direction is ascending so what will be the gain this child occurrence in those instances probably the last occur oh okay right so if it is descending it will be first if it will be ascending it will be last then I can now there is one more thing which is called this specific occurrence suppose if I had to extract the second eldest ii ii ii ii ii richard low coordination right is that because you are hot coding everything right in this case you're hard coding has to suppose if i want a if i want if i try to build a report and the report will have a parameter called i want a third child i want a second child I want the fourth child so is it you can father parameter this from hot coding them here no you have to do the hard coding itself okay right so in our case since you have to extract the like the L destroyed I'll just for the first offense since I'm sorting it wasn't on the ascending order a solid ascending order you sir nineteen that figure right so now what have what I have done is that I have extracted the eldest child instance complete instance I have extracted right complete instance means every data related to this LS shine will come whether it is a name date of birth or whatever data is being stored in the system all those things will come under in this instance itself but right so now I will show you what I have done till now so that we can keep a traffic well create a custom report as well and use these fields so that we can understand what is happening but still we are not filtered our employees whose you forget about I just create a custom report so let's just extract the employee ID now I have created that extract single instance on the business object worker right so I can use that calculated field directly on the worker visited site now suppose are the true/false fields which I had created can I use it directly under the worker business of this address on dependents right yes so I had to use that calculated field here I have to change the business of the different from welfare to dependent you have to use that particular to false calculated field also I'm just sure you're taking it in here so that I can show you what sort of data is coming in each of those fields but generally our viewers you will do put on the sub filter right yeah so right now note that when Sigma is now I'm not using any filter or separator forget about it right now right now I'm just showing what kind of data will come in each of these calculated it's all you have Emily all of you on the columns table okay okay my IDs I didn't see that our own can we have a brief description description of out that report anywhere in this report section so what type of data is giving what are the filter we added can we add that detail oh yeah got it thank you can I click OK and run this report not is see that right no since I have not done any kind of filtering any kind of that so what it is showing that for this particular employee the eldest child is safe honey okay right and it had I think it had like two children kind of so that is why unnecessary these roles are coming because I had I had used the dependent business object as well so the medium how the tryi name is coming because I need you stead extract single instance right so it so this is not the name Allah if you see the name is something like this which is not a knot and hyperlink this is coming as an hole instance so if I open this it will have all the details of this particular day dependent no no no no no I understand can you go to the report definition one more time go to the report definition report definition not the report all pointed I'm sorry man yeah now okay come down the last legal name okay that is or or dependent I am just putting in the whole single instance on the report that is now if you see any good very good the formation of the guide the definition of the term CF but there is no definition right because we created this instance right I just want to see can you go there what is there no no I didn't how this guy how this guy is getting the name instance everything is covered under the name itself that is for work there the name would be the instance the worker name would be the instance for dependents the name would be the instance and that instance will contain everything if you see depend Oh No can you please they did that CFO game worker soil data okay a little bit a second right in there you said source field is deployment dependent condition as this one it where do you specify I I want the name no that's what I'm saying but abit that is what I'm saying when you use this gap instead when you extract the instance right instance means everything will come as an instance that is it is an hyperlink hyperlink means that it will contain all the switch if when I clicked on this shakily you see it created a whole page for him right now from this instance we will extract what sort of data we want to pull out okay okay it so this is a complete instance it is it has nothing to do with like any specific requirement if you we have now with this move further and then your doubt will be cleared so now suppose my requirement was extract eldest child so now I'll change this requirement a bit first name so what are things which are their first name and date of birth suppose if I have to extract the first name and the date of birth or this particular eldest child so till now what we are getting is the instance right we are not getting it getting any specific value out of that instance now we have to extract these two values of mm-hmm now it will change that a look and feel for your things so now I have to extract the value from this extract single instance what I have to do so there's one more calculated field which we'll use to extract the data from the instance right and that calculated field is lookup related by the Spurs even from the detector she said relaxation hi so now what this lookup related value will does what it will do is it will take the instance as an input and then will will extract the particular field you want to put pitch out of it right so in that instance if you see there is one field called name which is shake a lien then there is one field called date of birth so we have to extract these fields out of those instances so if you have extract that field from those instances you have to create the look of related value calculated getting it yes so we will see how it is done so that makes more sense for you guys so I'll create a calculated ring now and we can look up a lady friend so now we have to create new calculator to look up a little value because we have to extract movies one is the mean and one is the date of birth right so when how many fields we have to extract from that instance that many you computed values you have to create in the system so since here we have to extract two fields we will create predict up a little line so first is the child a name and this again will be on the business object but because there are extract single instance is on the business object right function would be calculated value now what will be my lookup field here look a Philly where whatever age right know what will be my lookup a follicle related value it will be the instance we have created from so now if you see that we had extracted the symbol instance from the system right so using this instance only we have to extract the fields right right so my this instance would be my source field for lookup related values that will be my source field and now the field I have to extract has done me so the first name I have to extract so when I first calculated field has been created which is extracting the first name of that eldest child wife because this instance is only sending data eldest to child instance is that making sense yes right now another thing which you have to create is that extract the date of birth as well right so I'll go get another cap another calculated look evaluated value calculated the same things I will do the same things just few things which will change is our date of birth and business orders it's always worker reason these are excellent business also so now again I will use the same extracting than instance which is created and then return value I would need is so these two calculated fields I will use in my default who is your reporter this is my report so I'll add in the fields here so first I will use that first and argue that we did which was the chiming another - and my report now you see the difference that this was an hyperlink right because this was an instance now we have extracted particular fields which are coming as a text well you still maintain that that guy's the signaling since guy is still there it was a part of the report no no will be moving will I just wanted to show you the food right now let's say now since you see that even those employees are coming for this there is no my child data right usually now I'll use the fitness to show you how this filter works now then we move to CSI because it's not a part of a calculated field now I can use any of these two calculated fields as a part of my filter reasoning that is it is on the worker business object yes so I go to my you bring down all the day dozen worker CF underscore child me is not so this is what I said the bottom so now when I run my report a ferryman I see only those employees are coming who are having the child a child getting it yes sir we understand yeah so what I what it is like I just leave it for now just go through this recording once again okay through this recording once again because I am NOT created it in the like pennant which you are walking on so this is a fresh tenant web eased it is not there you can go to the recording and do the same thing replicate it and play with it in your day okay right okay right so is that all made sense whatever you learned today really good mud right so now let me ask you a question that why do we need the lookup related value and extract single instance the only reason being that first of all if you have to is extract a particular instance out of might instances we have to go for extract single instance and why we use the lookup related value so that we can bring that data on the work a lemon and you can apply it directly on the filters right yeah so so it is all I think you are right when you go on work with work in a workday yeah - if you work on a report happened to be right you see lot of calculated fields like the report is generally exactly so I tell you one of my experience when I had to create our 110 cal Philippines and each catalytic field had around three four sub calculated its ensign under let me ask this question mark okay how do you suppose you are running a running a report and the report is not producing as you expect you want to debug it so is any you have you have any debugging tool so that you know the in people take intermediate value for your calculated fields and all those things no there is no debugging tool you have to manually check like go to the my page and you see what kind of date I stole so you cannot run in a debug mode and you see what records are coming in and how the value is getting passed that is that kind of facility is not there no so you can directly then write if you run this report this is a debugging because you have a report with the heavy calculations and one of the calculation happened to be you know I happen to have a zero the denominator right those those things can happen right exactly so you I can tell you the panel one example we do is like we create another custom report when you then we will test only those calculated so you know I had all the feeds in that will keep on fitting our calculator please add one by one there guess whether it is working fine and then put it in our name right okay so that's how I try to replicate these things have it out spear related to attract single instance to false feels the capitulated value try to play with like what other related business objects you can use in the extract single instance are trying to think of some scenarios because now one more example as an exercise to work on I'll think on it and I'll share it to me okay I'll think on it and I'll share it for me but one example I can think of as like on the organization's and get the concept I know you can directly extract the cost center but think of it creating a lookup related valuing extracts in units so otherwise you can do the salsa write him I don't know find the fine be the first female kid kind of thing so probably you need to have a couple of more calculated field to figure out whether it is a girl child or not then you need to figure out the first girl checked yeah you can do that you see gender is gender is a column available but no is a girl or boy any photo from the photo picture may improve you right if they ask tell me the field name of a particular thing right that's where we will flop man no but see Bella I mean it's it's a fact that you directly cannot remember all the feeds to be very frank I mean even I cannot I will they would expect you to know that the what is a data cause for that right and that is why I'm telling you that if you have respect yes everything will be for you Bala this is Foster we are seeing in plane formation page you know so I mean the more practice you do the better it will be for like you to have all the data yeah scuse me man show me something so the interview equation will definitely consist of identify the name of a business or business or jeg to stuff like that or it will be like you know technical technical questions more on the logics balla so what they will ask is like how can you extract the eldest child from your worker bees then you have to tell the first of um you know to false to you based on the dependent object and then will create them extract single instance and then will be in the lookup related management so typically eighty percent of the questions see that also depends on the interviewer right if the interview is not having himself the logical knowledge then you go for the theoretical right I'll show you one example like even after my five years of experience when I applied for one job interview like they were pushing me to go for the interview so when I applied they asked me I like the interview question if I ask you like father or a nine years experience guy with five and a half years in workplace you will not ask what is the full form of Eid Vav yeah so the integration which we'll be talking about in the future so nobody will ask you the full form of Eid right okay getting it yes some good the full form of an eiv well that also depends on the interviewer as well that how much he knows and what sort of logic he wants to put it in front of you but any person the person is well aware of the move the technology he will never ask you about the particular field he'll always ask you about the logics how to business yeah that's a thing right I mean figuring we go to burb business object is okay you can figured out it's not a big deal right and see these are things are they practice at I mean whenever you are getting a tenant and whenever you're walking on a requirement you can explore all those things right these are not something that you have to remember you only have to remember the logics to build it so now to the scenario which you have told there is a field called gender in the dependent business object okay is it the formation yeah so now you have the sort of the scenario is extract the eldest to Choi who is a right way so that is kind of thing that you have to replicate in the day okay mm-hmm Charlotte walk on it I would like to see that everyone like get into this so that even I feel that I explained it up in a better way that you all extender stand right John I'll see you tomorrow guys well tomorrow we'll have 12 yeah tomorrow is Friday Thursday most right anyways yeah