Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listhelp to use calculated columnhelp to use calculated column
Previous
 
Next
New Post
7/26/2012 9:47 AM
 
ough

Joined: 2/15/2008
Posts: 33

I liked to use this module ,but i am facing a problem with the expression and scripting part.

I am trying to convert my Survey application  to be worked with FnL module

I already  used a calculated column named result:

result =[ A] + [B] +[ C ]+ [D] + [E] + [F] + [G]

A,B,C...  Set as Integer with a dropdownlist values (numbers) to be calculated later

So kindly i need your help with following

 Create an expression that reflect the following VB code:

         If result < 40 Then

          LBLcolumn= "Unaccepted"

       ElseIf result >= 40 Then
          LBLcolumn= "Accepted"

           If result<= 55 Then
               IfVal(MRcolumn) >= 800000 And Val(MRcolumn) <= 1500000 Then
                   MLcolumn=Val(MRcolumn) * 6
               ElseIfVal(MRcolumn) >= 1500001 And Val(MRcolumn) <= 2500000 Then
                   MLcolumn= Val(MRcolumn) * 7.5
               ElseIfVal(MRcolumn) >= 2500001 And Val(MRcolumn) <= 3500000 Then
                   MLcolumn= Val(MRcolumn) * 9
               ElseIfVal(MRcolumn) > 3500000 Then
                   MLcolumn= Val(MRcolumn) * 11
               EndIf
            ElseIfresult>= 56 Then
               IfVal(MRcolumn) >= 800000 And Val(MRcolumn) <= 1500000 Then
                   MLcolumn= Val(MRcolumn) * 8
               ElseIfVal(MRcolumn) >= 1500001 And Val(MRcolumn) <= 2500000 Then
                   MLcolumn= Val(MRcolumn) * 10
               ElseIfVal(MRcolumn) >= 2500001 And Val(MRcolumn) <= 3500000 Then
                   MLcolumn= Val(MRcolumn) * 12
               ElseIfVal(MRcolumn) >= 3500001 Then
                   MLcolumn= Val(MRcolumn) * 14
               EndIf

 

thank you

 
New Post
7/27/2012 7:17 AM
 
ough

Joined: 2/15/2008
Posts: 33
I did the following
Add a new column(named CLO)
then i added the below expression

IIf([Result]<56,IIf([MRcolumn]>=800000 And [MRcolumn]<=1500000,[MRcolumn]*6,IIf([MRcolumn]>=1500001 And [MRcolumn]<=2500000,[MRcolumn]*7.5,IIf([MRcolumn]>=2500000 And [MRcolumn]<=3500000,[MRcolumn]*9,IIf([MRcolumn]>3500000,[MRcolumn]*11)))),IIf([Result]>55,IIf([MRcolumn]>=800000 And [MRcolumn]<=1500000,[MRcolumn]*12,IIf([MRcolumn]>=1500001 And [MRcolumn]<=2500000,[MRcolumn]*13,IIf([MRcolumn]>=2500000 And [MRcolumn]<=3500000,[MRcolumn]*14,IIf([MRcolumn]>3500000,[MRcolumn]*15)))),"Out of Calc"))

but i got Invalid number of arguments: function IIf().

how ever i tested the above expression successfully with the ms access ?
 
New Post
7/29/2012 7:44 AM
 
Stefan Cullmann


Stefan Cullmann's Avatar

Joined: 1/6/2005
Posts: 2867

You cannot test with Access. The correct syntax is described here: http://msdn.microsoft.com/en-us/libra...

I would go step by step adding only one  iif statement  per iteration until you know what happens.
 
New Post
7/29/2012 7:49 AM
 
Stefan Cullmann


Stefan Cullmann's Avatar

Joined: 1/6/2005
Posts: 2867
One idea: what happens if you relpace "Out of calc" with 'out of calc' or even a number, e.g. -1?
 
New Post
7/30/2012 4:24 AM
 
ough

Joined: 2/15/2008
Posts: 33

I Tried to replace "Ou of Calc" with -1  (result Same problem)

I tried to use this expression IIf([Result]<56,IIf([MRcolumn]>=800000,[MRcolumn]*6,[Monthly Revenue]*1))(result Same problem)

Tried to use one IIF in my expression (Result  succeed )

Kindly Find Attached exported Module

<?xml version="1.0" encoding="utf-8" ?><content type="DNNUserDefinedTable" version="06.00.02"><UserDefinedTable xmlns="DotNetNuke/UserDefinedTable">
  <Data>
    <UserDefinedRowId>1</UserDefinedRowId>
    <First_x0020_Name>SAM</First_x0020_Name>
    <Last_x0020_Name>GH</Last_x0020_Name>
    <Customer_x0020_age>1</Customer_x0020_age>
    <Range_x0020_of_x0020_yearly_x0020_Revenues>5</Range_x0020_of_x0020_yearly_x0020_Revenues>
    <Others_x0020_yearly_x0020_Revenues>5</Others_x0020_yearly_x0020_Revenues>
    <Length_x0020_of_x0020_Employment>5</Length_x0020_of_x0020_Employment>
    <Employer_x0020_economical_x0020_sector>4</Employer_x0020_economical_x0020_sector>
    <Home_x0020_status>5</Home_x0020_status>
    <Marital_x0020_status>5</Marital_x0020_status>
    <Children_x0020_status>5</Children_x0020_status>
    <Current_x0020_Home_x0020_Loan>5</Current_x0020_Home_x0020_Loan>
    <Current_x0020_Car_x0020_Loan>5</Current_x0020_Car_x0020_Loan>
    <Current_x0020_Personal_x0020_Loan>5</Current_x0020_Personal_x0020_Loan>
    <Credit_x0020_Card>5</Credit_x0020_Card>
    <Current_x0020_other_x0020_Loans>5</Current_x0020_other_x0020_Loans>
    <Real_x0020_estate_x0020_properties>5</Real_x0020_estate_x0020_properties>
    <Medical_x0020_insurance_x0020_coverage>5</Medical_x0020_insurance_x0020_coverage>
    <Monthly_x0020_Revenue>15</Monthly_x0020_Revenue>
    <Maximum_x0020_Loan />
    <Score />
    <Loan_x0020_Result />
    <CLO>IIf([Score]&lt;57,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*6,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*7.5,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*9,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*11)))),IIf([Score]&gt;56,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*12,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*13,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*14,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*15)))),11111))</CLO>
    <Created_x0020_by>Sysadmin</Created_x0020_by>
    <Created_x0020_at>2012-07-26T10:03:43</Created_x0020_at>
    <Changed_x0020_by>Sysadmin</Changed_x0020_by>
    <Changed_x0020_at>2012-07-26T11:34:06</Changed_x0020_at>
  </Data>
  <Data>
    <UserDefinedRowId>2</UserDefinedRowId>
    <First_x0020_Name>ibrahim</First_x0020_Name>
    <Last_x0020_Name>hachem</Last_x0020_Name>
    <Customer_x0020_age>3</Customer_x0020_age>
    <Range_x0020_of_x0020_yearly_x0020_Revenues>5</Range_x0020_of_x0020_yearly_x0020_Revenues>
    <Others_x0020_yearly_x0020_Revenues>5</Others_x0020_yearly_x0020_Revenues>
    <Length_x0020_of_x0020_Employment>5</Length_x0020_of_x0020_Employment>
    <Employer_x0020_economical_x0020_sector>4</Employer_x0020_economical_x0020_sector>
    <Home_x0020_status>5</Home_x0020_status>
    <Marital_x0020_status>5</Marital_x0020_status>
    <Children_x0020_status>5</Children_x0020_status>
    <Current_x0020_Home_x0020_Loan>5</Current_x0020_Home_x0020_Loan>
    <Current_x0020_Car_x0020_Loan>5</Current_x0020_Car_x0020_Loan>
    <Current_x0020_Personal_x0020_Loan>5</Current_x0020_Personal_x0020_Loan>
    <Credit_x0020_Card>5</Credit_x0020_Card>
    <Current_x0020_other_x0020_Loans>5</Current_x0020_other_x0020_Loans>
    <Real_x0020_estate_x0020_properties>5</Real_x0020_estate_x0020_properties>
    <Medical_x0020_insurance_x0020_coverage>5</Medical_x0020_insurance_x0020_coverage>
    <Monthly_x0020_Revenue>15000</Monthly_x0020_Revenue>
    <Maximum_x0020_Loan />
    <Score />
    <Loan_x0020_Result />
    <CLO>IIf([Score]&lt;57,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*6,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*7.5,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*9,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*11)))),IIf([Score]&gt;56,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*12,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*13,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*14,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*15)))),11111))</CLO>
    <Created_x0020_by>Sysadmin</Created_x0020_by>
    <Created_x0020_at>2012-07-26T11:18:47</Created_x0020_at>
    <Changed_x0020_by>Sysadmin</Changed_x0020_by>
    <Changed_x0020_at>2012-07-26T11:35:14</Changed_x0020_at>
  </Data>
  <Data>
    <UserDefinedRowId>3</UserDefinedRowId>
    <First_x0020_Name>Hassan</First_x0020_Name>
    <Last_x0020_Name>Labban</Last_x0020_Name>
    <Customer_x0020_age>3</Customer_x0020_age>
    <Range_x0020_of_x0020_yearly_x0020_Revenues>0</Range_x0020_of_x0020_yearly_x0020_Revenues>
    <Others_x0020_yearly_x0020_Revenues>0</Others_x0020_yearly_x0020_Revenues>
    <Length_x0020_of_x0020_Employment>0</Length_x0020_of_x0020_Employment>
    <Employer_x0020_economical_x0020_sector>3</Employer_x0020_economical_x0020_sector>
    <Home_x0020_status>0</Home_x0020_status>
    <Marital_x0020_status>2</Marital_x0020_status>
    <Children_x0020_status>0</Children_x0020_status>
    <Current_x0020_Home_x0020_Loan>0</Current_x0020_Home_x0020_Loan>
    <Current_x0020_Car_x0020_Loan>0</Current_x0020_Car_x0020_Loan>
    <Current_x0020_Personal_x0020_Loan>0</Current_x0020_Personal_x0020_Loan>
    <Credit_x0020_Card>0</Credit_x0020_Card>
    <Current_x0020_other_x0020_Loans>5</Current_x0020_other_x0020_Loans>
    <Real_x0020_estate_x0020_properties>5</Real_x0020_estate_x0020_properties>
    <Medical_x0020_insurance_x0020_coverage>5</Medical_x0020_insurance_x0020_coverage>
    <Monthly_x0020_Revenue>15000</Monthly_x0020_Revenue>
    <Maximum_x0020_Loan />
    <Score />
    <Loan_x0020_Result />
    <CLO>IIf([Score]&lt;57,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*6,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*7.5,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*9,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*11)))),IIf([Score]&gt;56,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*12,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*13,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*14,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*15)))),11111))</CLO>
    <Created_x0020_by>Sysadmin</Created_x0020_by>
    <Created_x0020_at>2012-07-26T11:38:53</Created_x0020_at>
    <Changed_x0020_by>Sysadmin</Changed_x0020_by>
    <Changed_x0020_at>2012-07-26T12:26:38</Changed_x0020_at>
  </Data>
  <Data>
    <UserDefinedRowId>4</UserDefinedRowId>
    <First_x0020_Name>Mohamad</First_x0020_Name>
    <Last_x0020_Name>Akil</Last_x0020_Name>
    <Customer_x0020_age>5</Customer_x0020_age>
    <Range_x0020_of_x0020_yearly_x0020_Revenues>1</Range_x0020_of_x0020_yearly_x0020_Revenues>
    <Others_x0020_yearly_x0020_Revenues>0</Others_x0020_yearly_x0020_Revenues>
    <Length_x0020_of_x0020_Employment>0</Length_x0020_of_x0020_Employment>
    <Employer_x0020_economical_x0020_sector>3</Employer_x0020_economical_x0020_sector>
    <Home_x0020_status>0</Home_x0020_status>
    <Marital_x0020_status>2</Marital_x0020_status>
    <Children_x0020_status>0</Children_x0020_status>
    <Current_x0020_Home_x0020_Loan>0</Current_x0020_Home_x0020_Loan>
    <Current_x0020_Car_x0020_Loan>0</Current_x0020_Car_x0020_Loan>
    <Current_x0020_Personal_x0020_Loan>0</Current_x0020_Personal_x0020_Loan>
    <Credit_x0020_Card>0</Credit_x0020_Card>
    <Current_x0020_other_x0020_Loans>0</Current_x0020_other_x0020_Loans>
    <Real_x0020_estate_x0020_properties>0</Real_x0020_estate_x0020_properties>
    <Medical_x0020_insurance_x0020_coverage>0</Medical_x0020_insurance_x0020_coverage>
    <Monthly_x0020_Revenue>175000</Monthly_x0020_Revenue>
    <Maximum_x0020_Loan />
    <Score />
    <Loan_x0020_Result>IIF([score]&lt;40,[Loan Result] = Jones,2222)</Loan_x0020_Result>
    <CLO>IIf([Score]&lt;57,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*6,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*7.5,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*9,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*11)))),IIf([Score]&gt;56,IIf([Monthly Revenue]&gt;=800000 And [Monthly Revenue]&lt;=1500000,[Monthly Revenue]*12,IIf([Monthly Revenue]&gt;=1500001 And [Monthly Revenue]&lt;=2500000,[Monthly Revenue]*13,IIf([Monthly Revenue]&gt;=2500000 And [Monthly Revenue]&lt;=3500000,[Monthly Revenue]*14,IIf([Monthly Revenue]&gt;3500000,[Monthly Revenue]*15)))),11111))</CLO>
    <Created_x0020_by>Sysadmin</Created_x0020_by>
    <Created_x0020_at>2012-07-26T12:43:22</Created_x0020_at>
    <Changed_x0020_by>Sysadmin</Changed_x0020_by>
    <Changed_x0020_at>2012-07-26T12:43:22</Changed_x0020_at>
  </Data>
  <Fields>
    <UserDefinedFieldId>5</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>First Name</FieldTitle>
    <Required>true</Required>
    <FieldOrder>0</FieldOrder>
    <FieldType>String</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>true</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>First Name</ValidationMessage>
    <ValueColumn>First_x0020_Name</ValueColumn>
    <SortColumn>First_x0020_Name</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>6</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Last Name</FieldTitle>
    <Required>true</Required>
    <FieldOrder>1</FieldOrder>
    <FieldType>String</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>true</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Last Name</ValidationMessage>
    <ValueColumn>Last_x0020_Name</ValueColumn>
    <SortColumn>Last_x0020_Name</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>7</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Customer age</FieldTitle>
    <Required>true</Required>
    <FieldOrder>2</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>From 18 to 22 years|3;From 23 to 55 years|5;From 56 to 60 years|4;More than 60 years|1</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Customer age</ValidationMessage>
    <ValueColumn>Customer_x0020_age</ValueColumn>
    <SortColumn>Customer_x0020_age</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>8</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Range of yearly Revenues</FieldTitle>
    <Required>true</Required>
    <FieldOrder>3</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Less than USD 5,400|0;From USD 5,401 TO USD 8,400|1;From USD 8,401 to USD 24,000|3;From USD 24,001 to USD 60,000|4;More than USD 60,000|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Range of yearly Revenues</ValidationMessage>
    <ValueColumn>Range_x0020_of_x0020_yearly_x0020_Revenues</ValueColumn>
    <SortColumn>Range_x0020_of_x0020_yearly_x0020_Revenues</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>9</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Others yearly Revenues</FieldTitle>
    <Required>true</Required>
    <FieldOrder>4</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>true</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer has not another income|0;Less than USD 3,000|1;Between USD 3,001 and USD 15,000|3;More than USD 15,000|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Others, yearly Revenues</ValidationMessage>
    <ValueColumn>Others_x0020_yearly_x0020_Revenues</ValueColumn>
    <SortColumn>Others_x0020_yearly_x0020_Revenues</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>10</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Length of Employment</FieldTitle>
    <Required>true</Required>
    <FieldOrder>5</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Less than 1 year|0;Between 1 and 3 years|2;Between 4 and 12 years|4;More than 12 years|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Length_x0020_of_x0020_Employment</ValueColumn>
    <SortColumn>Length_x0020_of_x0020_Employment</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>11</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Employer economical sector</FieldTitle>
    <Required>true</Required>
    <FieldOrder>6</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Public Sector|3;Agriculture|1;Small Industry|3;Service sector|4;Information Technology|4;Financial Sector|5;Profession (engineer , lawyer , doctor…)|4</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Employer economical sector</ValidationMessage>
    <ValueColumn>Employer_x0020_economical_x0020_sector</ValueColumn>
    <SortColumn>Employer_x0020_economical_x0020_sector</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>12</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Home status</FieldTitle>
    <Required>true</Required>
    <FieldOrder>7</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Rented flat|0;lives with step parents|3;Self property|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Home status</ValidationMessage>
    <ValueColumn>Home_x0020_status</ValueColumn>
    <SortColumn>Home_x0020_status</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>13</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Marital status</FieldTitle>
    <Required>true</Required>
    <FieldOrder>8</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Married|2;Divorced|3;Widowed|2;Single|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Marital status</ValidationMessage>
    <ValueColumn>Marital_x0020_status</ValueColumn>
    <SortColumn>Marital_x0020_status</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>14</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Children status</FieldTitle>
    <Required>true</Required>
    <FieldOrder>9</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>More than four children|0;Three children|1;Two children|2;1 child|4;No children|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Children_x0020_status</ValueColumn>
    <SortColumn>Children_x0020_status</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>15</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Current Home Loan</FieldTitle>
    <Required>true</Required>
    <FieldOrder>10</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer has a current Home Loan|0;Customer has not a current Home Loan|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Current Home Loan</ValidationMessage>
    <ValueColumn>Current_x0020_Home_x0020_Loan</ValueColumn>
    <SortColumn>Current_x0020_Home_x0020_Loan</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>16</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Current Car Loan</FieldTitle>
    <Required>true</Required>
    <FieldOrder>11</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer has a current car Loan|0;Customer has not a current car Loan|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Current Car Loan</ValidationMessage>
    <ValueColumn>Current_x0020_Car_x0020_Loan</ValueColumn>
    <SortColumn>Current_x0020_Car_x0020_Loan</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>17</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Current Personal Loan</FieldTitle>
    <Required>true</Required>
    <FieldOrder>12</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer has a current personal Loan|0;Customer has not a current personal Loan|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Current Personal Loan </ValidationMessage>
    <ValueColumn>Current_x0020_Personal_x0020_Loan</ValueColumn>
    <SortColumn>Current_x0020_Personal_x0020_Loan</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>18</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Credit Card</FieldTitle>
    <Required>true</Required>
    <FieldOrder>13</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer hold a Credit Card|0;Customer does not Hold a Credit Card|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Credit Card</ValidationMessage>
    <ValueColumn>Credit_x0020_Card</ValueColumn>
    <SortColumn>Credit_x0020_Card</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>19</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Current other Loans</FieldTitle>
    <Required>true</Required>
    <FieldOrder>14</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer has another Loan|0;Customer has not another Loan|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Current other Loans</ValidationMessage>
    <ValueColumn>Current_x0020_other_x0020_Loans</ValueColumn>
    <SortColumn>Current_x0020_other_x0020_Loans</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>20</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Real estate properties</FieldTitle>
    <Required>true</Required>
    <FieldOrder>15</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer does not own any property|0;Customer does own property other than residence|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Real estate properties</ValidationMessage>
    <ValueColumn>Real_x0020_estate_x0020_properties</ValueColumn>
    <SortColumn>Real_x0020_estate_x0020_properties</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>21</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Medical insurance coverage</FieldTitle>
    <Required>true</Required>
    <FieldOrder>16</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>Customer has not a Medical insurance|0;Customer has  a social security coverage|4;Cust. has a Social Security +Med. Insur.|5;State official co.operative|4;State official co.operative + Med.Insur.|5;Army Forces Medical coverage|5;Medical Insurance coverage (In)|4;Medical Insurance coverage (In &amp; Out)|5</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Medical insurance coverage</ValidationMessage>
    <ValueColumn>Medical_x0020_insurance_x0020_coverage</ValueColumn>
    <SortColumn>Medical_x0020_insurance_x0020_coverage</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>24</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Monthly Revenue</FieldTitle>
    <Required>true</Required>
    <FieldOrder>17</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>true</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValidationMessage>Monthly Revenue</ValidationMessage>
    <ValueColumn>Monthly_x0020_Revenue</ValueColumn>
    <SortColumn>Monthly_x0020_Revenue</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>25</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Maximum Loan</FieldTitle>
    <Required>false</Required>
    <FieldOrder>18</FieldOrder>
    <FieldType>Int32</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Maximum_x0020_Loan</ValueColumn>
    <SortColumn>Maximum_x0020_Loan</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>26</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Score</FieldTitle>
    <Required>false</Required>
    <FieldOrder>19</FieldOrder>
    <FieldType>Expression</FieldType>
    <default>[Customer age]+[Range of yearly Revenues]+[Others yearly Revenues]+[Length of Employment]+[Employer economical sector]+[Home status]+[Marital status]+[Children status]+[Current Home Loan]+[Current Car Loan]+[Current Personal Loan]+[Credit Card]+[Current other Loans]+[Real estate properties]+[Medical insurance coverage]</default>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>String</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Score</ValueColumn>
    <SortColumn>Score</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>23</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Loan Result</FieldTitle>
    <Required>false</Required>
    <FieldOrder>20</FieldOrder>
    <FieldType>Expression</FieldType>
    <default>IIF([score]&lt;40,'Unaccepted','Accepted')</default>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>true</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>String</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Loan_x0020_Result</ValueColumn>
    <SortColumn>Loan_x0020_Result</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>27</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>CLO</FieldTitle>
    <Required>false</Required>
    <FieldOrder>21</FieldOrder>
    <FieldType>Expression</FieldType>
    <default>IIf([Score]&lt;57,(IIf([Monthly Revenue]&gt;=800000 ,[Monthly Revenue]*6,[Monthly Revenue]*20),"llll")</default>
    <Visible>true</Visible>
    <ShowOnEdit>true</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <InputSettings>String</InputSettings>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>CLO</ValueColumn>
    <SortColumn>CLO</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>4</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Created by</FieldTitle>
    <Required>true</Required>
    <FieldOrder>22</FieldOrder>
    <FieldType>CreatedBy</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>false</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Created_x0020_by</ValueColumn>
    <SortColumn>Created_x0020_by</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>3</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Created at</FieldTitle>
    <Required>true</Required>
    <FieldOrder>23</FieldOrder>
    <FieldType>CreatedAt</FieldType>
    <Visible>true</Visible>
    <ShowOnEdit>false</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Created_x0020_at</ValueColumn>
    <SortColumn>Created_x0020_at</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>2</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Changed by</FieldTitle>
    <Required>true</Required>
    <FieldOrder>24</FieldOrder>
    <FieldType>ChangedBy</FieldType>
    <Visible>false</Visible>
    <ShowOnEdit>false</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Changed_x0020_by</ValueColumn>
    <SortColumn>Changed_x0020_by</SortColumn>
  </Fields>
  <Fields>
    <UserDefinedFieldId>1</UserDefinedFieldId>
    <ModuleID>450</ModuleID>
    <FieldTitle>Changed at</FieldTitle>
    <Required>true</Required>
    <FieldOrder>25</FieldOrder>
    <FieldType>ChangedAt</FieldType>
    <Visible>false</Visible>
    <ShowOnEdit>false</ShowOnEdit>
    <Searchable>false</Searchable>
    <PrivateField>false</PrivateField>
    <MultipleValues>false</MultipleValues>
    <NormalizeFlag>false</NormalizeFlag>
    <ValueColumn>Changed_x0020_at</ValueColumn>
    <SortColumn>Changed_x0020_at</SortColumn>
  </Fields>
  <FieldSettings>
    <FieldId>3</FieldId>
    <SettingName>ConvertToUserDateTime</SettingName>
    <SettingValue>False</SettingValue>
  </FieldSettings>
  <FieldSettings>
    <FieldId>4</FieldId>
    <SettingName>AsLink</SettingName>
    <SettingValue>False</SettingValue>
  </FieldSettings>
  <FieldSettings>
    <FieldId>4</FieldId>
    <SettingName>OpenInNewWindow</SettingName>
    <SettingValue>False</SettingValue>
  </FieldSettings>
  <FieldSettings>
    <FieldId>4</FieldId>
    <SettingName>PreferDisplayName</SettingName>
    <SettingValue>False</SettingValue>
  </FieldSettings>
  <FieldSettings>
    <FieldId>23</FieldId>
    <SettingName>RenderInForm</SettingName>
    <SettingValue>False</SettingValue>
  </FieldSettings>
  <FieldSettings>
    <FieldId>26</FieldId>
    <SettingName>RenderInForm</SettingName>
    <SettingValue>True</SettingValue>
  </FieldSettings>
  <FieldSettings>
    <FieldId>27</FieldId>
    <SettingName>RenderInForm</SettingName>
    <SettingValue>False</SettingValue>
  </FieldSettings>
  <Settings Setting="CalculatedColumnsRenderExpressionInForm" Value="True" />
  <Settings Setting="hideadminborder" Value="False" />
  <Settings Setting="searchonce" Value="False" />
  <Settings Setting="UDT_EditOnlyOwnItems" Value="False" />
  <Settings Setting="UDT_EditPrivateColumnsForAdmins" Value="False" />
  <Settings Setting="UDT_ExcludeFromSearch" Value="True" />
  <Settings Setting="UDT_Filter" Value="" />
  <Settings Setting="UDT_ForceCaptchaForAnonymous" Value="False" />
  <Settings Setting="UDT_ForceFiltering" Value="False" />
  <Settings Setting="UDT_ListNotFormsMode" Value="Form" />
  <Settings Setting="UDT_Paging" Value="30" />
  <Settings Setting="UDT_RenderingMethod" Value="DataGrid" />
  <Settings Setting="UDT_ShowAllColumnsForAdmins" Value="False" />
  <Settings Setting="UDT_ShowNoRecordsUntilSearch" Value="False" />
  <Settings Setting="UDT_ShowSearchTextBox" Value="True" />
  <Settings Setting="UDT_ShowSystemColumns" Value="False" />
  <Settings Setting="UDT_SimpleSearch" Value="False" />
  <Settings Setting="UDT_SortField" Value="" />
  <Settings Setting="UDT_SortOrder" Value="" />
  <Settings Setting="UDT_Submission_succeeded" Value="Your submission was successful." /&g

 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listhelp to use calculated columnhelp to use calculated column


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out