reset - evaluate or..

[Former Member]

Post Author: shedevel143

CA Forum: Formula

I have a formula : IF {Customers.PriceLevel} = 0 THEN {LineItem.PriceLevel1Amount} ELSEIF {Customers.PriceLevel} = 1 THEN {LineItem.PriceLevel2Amount} ELSEIF {Customers.PriceLevel} = 2 THEN {LineItem.PriceLevel3Amount} ELSEIF {Customers.PriceLevel} = 3 THEN {LineItem.PriceLevel4Amount} ElseIF {Customers.PriceLevel} = 4 THEN {LineItem.PriceLevel5Amount} ElseIF {Customers.PriceLevel} = 5 THEN {LineItem.PriceLevel6Amount} ElseIF {Customers.PriceLevel} = 6 THEN {LineItem.PriceLevel7Amount} ElseIF {Customers.PriceLevel} = 7 THEN {LineItem.PriceLevel8Amount} ElseIF {Customers.PriceLevel} = 8 THEN {LineItem.PriceLevel9Amount} ElseIF {Customers.PriceLevel} = 9 THEN {LineItem.PriceLevel10Amount}

This works if only I on the 4-5 lines. I get no error when I save the formula and dint get data. Also, when it does work it give the right price but I need it to reset or...

My report should looks like this:

customer id Price level Item Id Price level amount

Joe blow 0 xxx-000 55.00

Joe blow 0 xxx-222 65.00

Helen Monkey 1 xxx-000 60.00

Helen Monkey 1 xxx-000 .80.00

However, I only get one line item per customer. I assume I need to tell it to reset or evaluate after each item id. Help!!!

thanks in Advance

[Former Member]

Post Author: synapsevampire

CA Forum: Formula

Hmmm, bad day I guess, better mellow a tad, thanks for the input

-k

[Former Member]

Post Author: SKodidine

CA Forum: Formula

C'mon Kai, cut the user some slack. If the post isn't clear then no one will respond and the user will realize that perhaps what they asked for isn't clear. These forums are used by CR developers from all over the world and to expect everyone to post their questions in perfect English is not realistic.

You are usually pretty relaxed in your posts, what's going on mate? You seem pretty 'snappy' today!

[Former Member]

Post Author: synapsevampire

CA Forum: Formula

Post basic technical information: Crystal version, database, report layout (grouping, etc.), example data, expected output.

You post a formula and the expected output and we're to divine what the original data looks like and what the current output is, amongst other things.

Also what does "This works if only I on the 4-5 lines" mean? Does that seem like a logical sentence to you?

-k