Lars Kjær

1. Community
2. Frontend, Designer and Consumer
3. Seeking Assistance with Average Employee-Citizen Ratio Calculation in Elderly Care Reporting

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...

• View comment
• Created February 20, 2024 10:35
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Creating Price Forecast and Calculation in Calculation Fields Based on Field Content in Frontend

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

• View comment
• Created January 18, 2024 16:57
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Creating Price Forecast and Calculation in Calculation Fields Based on Field Content in Frontend

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

• View comment
• Created December 29, 2023 12:24
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Creating Price Forecast and Calculation in Calculation Fields Based on Field Content in Frontend

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...

• View comment
• Created December 29, 2023 11:27
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Aggregating "Ledig i hele perioden" for "Boligenheder"

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

• View comment
• Created December 28, 2023 14:42
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Aggregating "Ledig i hele perioden" for "Boligenheder"

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...

• View comment
• Created December 28, 2023 14:13
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Aggregating "Ledig i hele perioden" for "Boligenheder"

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...

• View comment
• Edited December 28, 2023 13:25
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Aggregating "Ledig i hele perioden" for "Boligenheder"

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. ...

• View comment
• Created December 28, 2023 12:59
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Aggregating "Ledig i hele perioden" for "Boligenheder"

Hi Niels. Thank you very much for your prompt response. To elaborate: In the first picture, there is a black ring around "0" next to Enebærvej.... On Enebærvej, both Enebærvej 32 and Enebærvej 6 ha...

• View comment
• Created December 28, 2023 12:49
• 0 votes