AnsweredAssumed Answered

Is it possible to calculate on each row in a portal without having a calculation field in the related table that is shown in the portal?

Question asked by makfuji on Apr 12, 2017
Latest reply on Apr 14, 2017 by philmodjunk

In my app, it has a portal that is displaying a related table(This is about bill detailed statement which item bought).

The related table has fields such as "date", "item_no", "amount", "unit price".

There is a record called "the number of bills(assuming  item_no=999) that tells me how many customer came on that day"

The rest of the records are something like "apple(item_no=001)", "orange(item_no=002" and so on.

I'd like to show the ratio of these each item against the number of the bills on each day that is being displayed on each row in the portal.

Can I make it calculate and show the result somehow?

 

Or do I always have to have the calculation field in the related table which is calculated by self relation(related with date, and item_no to count the number of the bill")

Outcomes