lclayton1997

Calculated field not populating

Discussion created by lclayton1997 on Feb 26, 2018
Latest reply on Feb 27, 2018 by davidhead

Hi - I need help.

I inherited an existing (very large) database and was asked to add to new fields to a chart.

I added the fields and now the calculated field is not bringing back any results so I must have broke it somehow.

 

This is what I can tell exists and all I did was follow suit and add the new fields.

I'm not really sure what is being used but I did add the two new fields everywhere I found the other ones.

 

Layout COGS tab called PD Process has two fields:

1. "Issue Price 1" under table "PD Process".

    It is a number and is indexed.

2. "Issue Price" is a value list that contains the list of all the issues prices. This is a drop down list user selects from.

3. "Shipping 1" is a calculated number field.

    basically it looks up the issue price and is supposed to bring back the shipping rate based on the "issue price"

    selected. 

4. "Rate schedule" layout has fields under table "rate charts"

    The chart has fields for each shipping rate and the chart is updated every year by typing in the corresponding value.

     for example: Shipping 499.99 field has 50.99 typed in that field.

 

I believe that is all there is to it. But when I added the 2 new rates to the calculation, the shipping 1 field is blank regardless which Issue price is selected.

 

Here is the calculation I added the 399.99 and the 499.99 to.

I did insert it before the 19.99 which was already there.

 

If( Issue Price 1 = "29.99"; Rate Charts::Shipping 29.99) & If( Issue Price 1 = "34.99"; Rate Charts::Shipping 34.99) & If( Issue Price 1 = "39.99"; Rate Charts::Shipping below 39.99) & If(Issue Price 1 = "49.99"; Rate Charts::Shipping 49.99) & If( Issue Price 1 = "59.99"; Rate Charts::Shipping 59.99) & If( Issue Price 1 = "69.99"; Rate Charts::Shipping 69.99) & If( Issue Price 1 = "79.99"; Rate Charts::Shipping 79.99) & If( Issue Price 1 = "89.99"; Rate Charts::Shipping 89.99) & If( Issue Price 1 = "99.99"; Rate Charts::Shipping 99.99) & If( Issue Price 1 = "109.99"; Rate Charts::Shipping 109.99) & If( Issue Price 1 = "119.99"; Rate Charts::Shipping 119.99) & If( Issue Price 1 = "125"; Rate Charts::Shipping 125)  & If( Issue Price 1 = "129.99"; Rate Charts::Shipping 129.99) & If( Issue Price 1 = "139.99"; Rate Charts::Shipping 139.99) & If( Issue Price 1 = "149.99"; Rate Charts::Shipping 149.99) & If(Issue Price 1="159.99"; Rate Charts::Shipping 159.99) & If( Issue Price 1 = "169.99"; Rate Charts::Shipping 169.99) & If( Issue Price 1 = "179.99"; Rate Charts::Shipping 179.99) & If( Issue Price 1 = "189.99"; Rate Charts::Shipping 189.99) & If( Issue Price 1 = "199.99"; Rate Charts::Shipping 199.99) & If( Issue Price 1 = "229.99"; Rate Charts::Shipping 229.99) & If( Issue Price 1 = "249.99"; Rate Charts::Shipping 249.99) & If( Issue Price 1 = "299.99"; Rate Charts::Shipping 299.99) & If( Issue Price 1 = "399.99"; Rate Charts::Shipping 399.99) & If( Issue Price 1 = "499.99"; Rate Charts::Shipping 499.99) & If( Issue Price 1 = "19.99"; Rate Charts::Shipping 19.99)

Outcomes