Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
mitjap
Contributor III
Contributor III

Sum in tables

I came to the problem that i hard for me to overcome.

i added screen shot as data files are big

in right table everything is correct as i use to calculate "kos" this expression:

if(Count([Ime delavca])=2,(sum(if(Delavci=2,((kol)/2)))) + (sum(if(Delavci=1,((kol))))), (sum(if(Delavci=2,((kol))))) + (sum(if(Delavci=1,((kol))))))

it uses other fields so i can filter out thing

it works great as i use in table "dat.autocalendar.date" and "kataloška".

the problems is on left table as i dont have "dat.autocalendar.date" and "kataloška" in table. my count and same expresion wont work in left table.

is there possibility that i write expression in left table on the way that is calculate the same as in right table?

 

 

 

 

 

0 Replies