Linkage Rules-Multi Condition combine result for sum calculation

Hello,

As below image show that I have did 2 linkage rules for different condition, but the final expression seem sum for both condition. Suppose the amount sum is seperate by type choose.

Kindly advise.
Thanks you

Hello,

Anyone can assist?
Thanks.

Please rethink the condition. It returns true or false to decide if properties should be executed, instead of filtering data of assessment type = income to execute properties.

1 Like

Hello,

Just ask, any possible to include sql expression inside the Linked Rules?

1 Like

SQL is not supported. How about splitting these two types into separate fields? You can select and calculate them individually.

Hello,

Yes, Im thinking that way too, but I will having multiple “Assessment Type” and suppose requirement many seperate field then. I do try some method make it some formula to keep the value first before get total/sum, its works, but the field must be show on the same table, if not it will not really calculate. The issue is, i cant “hide” it on the table.

The formula to verify/seperate for the selection type

image

Still try any method for solve this.

There is a new feature to hide column in the next branch.

Hi,
Thank you for your reply.
Nice function. Unfotunately Im using version Main v.1.3.50 Beta and far away to the latest version…I do check on Release Notes, latest version recently release is Main 1.4.2 on 4 Dec, but when try to pull update, never get any latest update.Update release depends on country location?

Hello,

I do fix the issue cannot get update to the latest version…Now version is update to v 1.4.0 and yes…the function hide able use now. Consider my issue solve now…
Thanks you so much .Yokatta" (よかった) :smiling_face_with_three_hearts: :smile: :grinning: