Problem linking Fieldnames from different tables

[#1]

Dear all,

See here a problem that I’m struggling to find a solution.

The main problem can be attributed to message “One or more loops have been detected in your database structure”.

I want to create a plot actual costs versus budget costs.

Blue line is actual, representing cumulative costs.Red line is the budget. Budget values changes from month to month.

The Table box contains the data:

You can see that the date, created from MasterCalendar, frequently shows no costs.The plot works fine, but:

when I click on costs group EAG from this list:

1) Then the plot does not show all days of the months (from 1 jan 2016 up to today.

2) In addition, the budget (red) line is not correct because it did not select the correct costs group. Not a surprise since the fieldname “Group_” for defining Costs group in the “Budget3” table cannot be linked with ‘Group” from “Expenditure” table. Converting “Group_”  into Group gives me the error reporting : One or more loops have been detected in your database structure”.

Do you see any solution how to solve this?

Best regards,

Cornelis 

[#2]

Dear Sunny,

Yes, that is eactly what I'm looking for.

The expression SUM({<Group_ = p(Group), Group>}[Budget YTD])

is showing me a linear increase (cumulative sum) over month days.

Nice and very instructive expression!

This excellent and a big improvement.

Thank you for all your effort