Finance | Project Operations, Human Resources, ...

Electronic reporting (calc. field)

(0) Share

Report

Posted on by Abdullah.Y

Hi
i want to create a ER as item , sls qty, prod qty, pur qty etc
for this
i am taking the datasource as InventTrans and i want to get the vlaues of Sales , prod, purhcase etc based on transorigin.ReferenceCategory (for exmaple if categoy is zero it is sales)
i am trying to create a calculated field with below formula (where @ is the inventtrans table)

1.) my question is how to sum the qty based on different categories
2.) do i have to create different calc fields for Prod and purch etc.,
3) when iam trying to create Calc field like below iam getting error

if(@.‘InventTransOrigin.ReferenceCategory’==0,@.Qty,0)

Syntax error: We found a problem with this formula; syntax error near ‘(’

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Arcadi 794 on at

Like (0)

Report

Reference Category is not a number, is an Enum, you have to insert the enum "InventTransType" and then:

if(@.‘InventTransOrigin.ReferenceCategory’==InventTransType.Sales,@.Qty,0.0)

Was this reply helpful? Yes No
Abdullah.Y 5 on at

Like (0)

Report

actually i tried that also but stil the same syntax error

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Abdullah,

Can you provide more info about your model so we can assist better.

Regarding the formula you cannot have to equals, IF(@.‘InventTransOrigin.ReferenceCategory’=0,@.Qty,0)

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

I have check InventTransOrigin table and Reference(ReferenceCategory) field is related to InventTransType as Enum

What is your business requirement?

Was this reply helpful? Yes No
Abdullah.Y 5 on at

Like (0)

Report

i want to create a ER report from inventtrans Table

item | sls qty |prod qty |purch qty|

for this i selected the inventtrans table as datasource

now for getting sales value ( for example) iam trying to create a calc field using if statement

if the ref category is sales ( "0" or InventTransType.Sales) , then the value should be the inventrans.Qty else 0

but iam getting error

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

You can use following calculated field on InventTrans

You need to define Enum for InventTransType in advanced!

WHERE(

InventTrans,

InventTrans.'inventTransOrigin()'.ReferenceCategory = Enum.InventTransType.Sales)

Then on the field mapping you can define that quantity comes from that calculated field.

Was this reply helpful? Yes No