As we are inline we can’t report from more than two objects from a report perspective:

Below is the requirement:

Example:

Total cost getting from 2 objects in to a report: 100 USD (using HTML Component)

I need to get the breakdown of above from multiple objects (using HTML Component)

Assume:

Storage cost: 10 USD I have got this from multiple objects (2 Objects) (Using HTML Component)

Compute cost: 50 USD I have got this from multiple objects (2 Objects) (Using HTML Component)

End User cost: 10 USD I have got this from multiple objects (2 Objects) (Using HTML Component)

Communication cost: 5 USD I have got this from multiple objects (2 Objects) (Using HTML Component)

Tickets cost: 5 USD I have got this from multiple objects (2 Objects) (Using HTML Component)

Till the above it’s been achieved

Now I need to get the remaining breakdown cost using above: Breakdown cost=Total Cost-(Storage+Compute+End User+Communication+Tickets) 20 USD Via HTML or any other work around.

Please share your thoughts and workaround on this!!

Hi there,

Something along the lines of this should work:

Because I do not know your data set names I will call them Data1 and Data2, and I will refer to the column containing values "Storage", "Compute", "End User" etc.. as "CostType". I will refer to the value column as "Cost"

<%=numberformat(Data1:Cost[CostType!="Storage" AND CostType!="Compute" AND CostType!="End User" AND CostType!="Communications" ANDCostType!="Tickets"]+Data2:Cost[CostType!="Storage" AND CostType!="Compute" AND CostType!="End User" AND CostType!="Communications" ANDCostType!="Tickets"])%>

Please let me know if this helps, or if you need any more clarification

Best,

Maxwell

But this allow only using 2 modelled sets.....

The exact requirement is:

Total Application Cost = $100 (received from multiple objects 2 objects in reporting)

Storage Cost = $20 (received from multiple objects 2 objects in reporting)

Compute Cost = $30 (received from multiple objects 2 objects in reporting)

End User Cost = $10 (received from multiple objects 2 objects in reporting)

Ticket Cost = $10 (received from multiple objects 2 objects in reporting)

Communications Cost = $10 (received from multiple objects 2 objects in reporting)

Till the above steps achieved through HTML , Below is the requirement in reporting below via HTML

Break down cost= Total Cost-(Storage+Compute+End User+Ticket+Communications) = $20 ($100-($20+$30+$10+$10+$10)

You can use the HTML above to pull data from as many objects as you need. Just replicate the code out for each one

Or maybe I am not understanding the problem correctly?