# Lars Kjær

• Total activity 15
• Last activity
• Member since
• Following 0 users
• Followed by 0 users
• Subscriptions 3

## Activity overview

Latest activity by Lars Kjær
• Lars Kjær commented,

Hi Niels, that was exactly what I needed - thank you very much. I've been struggling with these aggregations to a higher level, but now, with your help on 2 support cases, I hope I can utilize this...

• Lars Kjær created a post,

### Seeking Assistance with Average Employee-Citizen Ratio Calculation in Elderly Care Reporting

Hello Targit BI forum, I need help understanding a calculation. I work with data in the elderly care sector, and there is a significant focus on obtaining visible management information about the c...

• 2 followers
• Lars Kjær commented,

Thanks a lot, Ole - I will try this :-)   Best regards / Lars

• Lars Kjær commented,

Thank you for the great suggestions :-) I will work on them further. Happy New Year

• Lars Kjær commented,

Hi Marlene. Thank you for the creative suggestion, which, of course, means that I need to figure out in which positions the individual organizations are displayed. I've tried updating my small shee...

• Lars Kjær created a post,

### Creating Price Forecast and Calculation in Calculation Fields Based on Field Content in Frontend

I have a desire to be able to create a price and calculation via the frontend in calculation fields. Below are data for 'Organisation Level 4' and 'Visited time.' I would like to be able to create ...

• Edited
• 3 followers
• Lars Kjær commented,

A thousand thanks. Now I understand, and it works exactly as it should. Thank you for the quick assistance and your patience :-)

• Lars Kjær commented,

Hi again. Formel 4 = If allcount(c5,all(c),m1)>0 then sum(c5,all(c),m1) else sum(c5,0,m1) Formel 5 = if sum(c6,0,m1) = 0 then 0 else sum(c6,0,m1)/sum(d1,0,m1) Unfortunately, it seems that Formula 4...

• Lars Kjær commented,

I have inserted the new formula as "Formula 3". It appears to count correctly for individual homes, the housing unit, and the area. However, the overall total is not correct; it shows "2". In compa...

• Lars Kjær commented,

I have inserted your two suggestions as "Formula 1" and "Formula 2". "Formula 1" does not seem to count correctly for the housing unit. Under Enebærvej, it shows "1", but there are 2 vacant homes. ...