Dave,

I tried this in my developer org. that is on Skuid 10.0.4. What you are trying to do works. I have included my XML that does a count of tasks by WhoId and calculates a percentage.

In looking at your post, I noticed that in your 3rd paragraph your model name is ‘TimesheetentryAgg’.

In your 5th paragraph, you show your model lookup as MODEL_LOOKUP(“timesheetEntryAgg”,“TotalPaid”).

Notice that the ‘t’ in your model lookup is NOT capitalized. That may be your problem. I would verify that your first model has a row in it and then carefully check that your model name and model field in your model lookup UI field match your first aggregate model.

Thanks,

Bill

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">

    <models>

        <model id="TotalTasks" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Task">

            <fields>

                <field id="Id" name="countIdTask" function="COUNT"/>

            </fields>

            <conditions/>

            <actions/>

            <groupby method="simple"/>

        </model>

        <model id="TasksByWhoId" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="Task">

            <fields>

                <field id="Id" name="countIdWho" function="COUNT"/>

                <field id="Percentage" uionly="true" displaytype="FORMULA" label="Percent of Total" ogdisplaytype="TEXT" readonly="true" returntype="PERCENT" precision="3" scale="2">

                    <formula>{{countIdWho}}/MODEL_LOOKUP("TotalTasks","countIdTask")*100</formula>

                </field>

            </fields>

            <conditions/>

            <actions/>

            <groupby method="simple">

                <field id="WhoId" name="whoId"/>

                <field id="Who.Name" name="whoName"/>

            </groupby>

        </model>

    </models>

    <components>

        <pagetitle model="TotalTasks" uniqueid="sk-3wyOpP-175">

            <maintitle>Total Tasks:  {{$Model.TotalTasks.data.0.countIdTask}}</maintitle>

            <actions/>

        </pagetitle>

        <skootable showconditions="true" showsavecancel="false" showerrorsinline="true" searchmethod="server" searchbox="true" showexportbuttons="false" pagesize="10" alwaysresetpagination="false" createrecords="false" model="TasksByWhoId" buttonposition="" mode="readonly" allowcolumnreordering="true" responsive="true" uniqueid="sk-3wyj7V-226">

            <fields>

                <field id="Who.Name" name="whoName" hideable="true" uniqueid="fi-3wykkT-236"/>

                <field id="Id" name="countIdWho" hideable="true" uniqueid="fi-3wykkT-237" valuehalign="" type="">

                    <label>Number of Tasks</label>

                </field>

                <field id="Percentage" hideable="true" uniqueid="fi-3wz8Vf-402" decimalplaces="" valuehalign="" type=""/>

            </fields>

            <rowactions/>

            <massactions usefirstitemasdefault="true"/>

            <views>

                <view type="standard"/>

            </views>

        </skootable>

    </components>

    <resources>

        <labels/>

        <javascript/>

        <css/>

    </resources>

    <styles>

        <styleitem type="background" bgtype="none"/>

    </styles>

</skuidpage>

Hi Bill,

Thank you for your help.

Unfortunately the typo was in post only… i wrote it in a hurry , sorry

I looked at your example, ty for providing it and it seems liek u said i’m doing things correctly.

So still cannot figure out issue

So here’s SS from every step , maybe it will help?

I’m not very good at working with console, but trying to lookup model to see if UI field has value , but do not see it at all there (is it normal?)

Thank you!

I found the culprit!

Instead of just looking at the builder page, I decided to test your page Bill, once i made some changes on it to work on my org

and realized it did not return results as well…

You mentioned u tested it on 10.0.0.4 , so tested it on my sandbox on which i was testing latest version and it worked!

My Production org is still under 8.15.14 … not sure why it’s not working on this version, but in case someone has same issue, here’s the answer

Don’t put off too long updating skuid like me (i try to not update too often as it takes me a lot of time to test all of our pages and other items that uses skuid to make sure no crucial bug and all working as it should , hope SF allows rollbacks soon!)

Does anyone know if this is a new feature that came in after 8.15 version?

Thx