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)

Sort by

Suggested answer

Arcadi 796 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

actually i tried that also but stil the same syntax error

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,849 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,849 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,849 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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