fieldcontent as a new field

[#1]

hello community,

I will try to discribe my problem in english:

I have a table with the fields

attr_value (project number)

rel_attr_id (ZE for budget € or ZM for budget mandays)

rel_value (the amount of the budget, in € or mandays, depending on rel_attr_id)

As i want to calculate the rates (budget euro / budget mandays) I need to have the fieldcontents of rel_attr_id as seperate fields, for example I sould end up with one table with the fields

attr_value:

Budget EUR

Budget Mandays.

hope you understand my problem,

regards

Astrid Hermann

[#2 · Accepted solution]

Hi all,

i solved it quite simple:

if (rel_attr_id = 'ZM',rel_value)as budget_md,

if (rel_attr_id = 'ZE',rel_value)as budget_eur,